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

Showing Answers 1 - 4 of 4 Answers

samareshp

  • Feb 13th, 2010
 

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

  Was this answer useful?  Yes

Give your answer:

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

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions