GeekInterview.com
Series: Subject: Topic:
Question: 99 of 290

What is the difference between right join and right outer join..

Asked by: Interview Candidate | Asked on: Aug 6th, 2007
Showing Answers 1 - 4 of 4 Answers
ramaswamy80in

Answered On : Sep 26th, 2007

View all answers by ramaswamy80in

when we join two tables  if one of them is deficient of rows then we use outer jion 
if the  right side table is deficient of rows we use right outer join and vise versa

Yes  1 User has rated as useful.
  
Login to rate this answer.
mohit_aren

Answered On : Feb 13th, 2008

View all answers by mohit_aren

The RIGHT JOIN is short of RIGHT OUTER JOIN with effect remaining same.

  
Login to rate this answer.

Both are same. Right outer join returns all the reocrds that satisfy the join condtion + rest of the records from right (or second) table.

Yes  3 Users have rated as useful.
  
Login to rate this answer.
samareshp

Answered On : Feb 13th, 2010

View all answers by samareshp

Both are same.
outer join : We have 3 types of outer joins. Left Oute, Right Outer and Full Outer join.

Left outer join:

Select * from lefttable, righttable where lefttable.col1=righttable.col1(+)
This will retrive all the rows present in the lefttable irrespective of it matched with the righttable.

Right Outer Join:
Select * from lefttable, righttable where lefttable.col1(+)=righttable.col1
This will retrive all the rows present in the righttable irrespective of it matched with the lefttable.

Full Outer Join:
Select * from lefttable, righttable where lefttable.col1=righttable.col1(+)
union
Select * from lefttable, righttable whe

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.