MYSQL - How do you use Outer Join in MySQL

GeekInterview.com > Interview Questions > Database > MYSQL

Go To First | Previous Question | Next Question

MYSQL | Question 42 of 46

How do you use Outer Join in MySQL

Total Answers and Comments: 4

Last Update: February 13, 2008 Asked by: lekhrajdeshmukh

Sponsored Links

Best Rated Answer

—

Submitted by: sampra

select sname,phone,feebal,feepaid from student s left outer join fees f
on s.sid=f.sid;

union

select sname,phone,feebal from student s right outer join fees f on s.si
d=f.sid;

u can use this compile code

Above answer was rated as good by the following members:
jeremymckay

February 12, 2008 23:22:58

sampra

Member Since: February 2008 Contribution: 279

RE: How do you use Outer Join in MySQL

Out join has 3 categry 1.left2.right3.full which youu want??

Is this answer useful? Yes | No

February 13, 2008 05:14:56

lekhrajdeshmukh

Member Since: November 2007 Contribution: 4

RE: How do you use Outer Join in MySQL

actually i want ot know about full outer join.

Is this answer useful? Yes | No

February 13, 2008 06:46:45

sampra

Member Since: February 2008 Contribution: 279

RE: How do you use Outer Join in MySQL

you cant get it directly take left outer join and right outer join and then take union of both

Is this answer useful? Yes | No

February 13, 2008 06:50:21

sampra

Member Since: February 2008 Contribution: 279

RE: How do you use Outer Join in MySQL

select sname,phone,feebal,feepaid from student s left outer join fees f
on s.sid=f.sid;

union

select sname,phone,feebal from student s right outer join fees f on s.si
d=f.sid;

u can use this compile code

Is this answer useful? Yes | No

2 1

Overall Rating: +1

Go To Top