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

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

  1 User has rated as useful.

  

Login to rate this answer.

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

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

  3 Users have rated as useful.

  

Login to rate this answer.

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