Dear Senior members,
There are left outer join and right outer join in oracle.
Suppose there two tables A(col1,col2,col3) and B(col1,col4,col5) .
If I perform Data1= select A.col1, col2,col4 from A left outer join B on A.col1=B.col1;
Data2= select A.col1, col2,col4 from A Right outer join B on A.col1=B.col1;
Data3= select A.col1, col2,col4 from B left outer join A on A.col1=B.col1;
Here outcome is Data2=Data3
if I can get Data3 by just swapping the tables A's and B's positions then why oracle has other outer join.
(I mean if I''ll use left outer join then there is no need of right outer join because I can achieve right outer join's result by just swapping the positions of table A and B in left outer join and vice-versa ).
Please guide.
Thanks & Regards Ram