ramaswamy80in

 Profile Answers by ramaswamy80in 

• Sep 26th, 2007

 

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

mohit_aren

 Profile Answers by mohit_aren 

• Feb 13th, 2008

 

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

krishnaindia2007

 Profile Answers by krishnaindia2007 

• May 13th, 2008

 

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

samareshp

 Profile Answers by 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