var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Difference in Left Outer and Right Outer Join
We all knows the difference between a Left and Right Outer Join,
Lets says we have two tables A and B.
A a Left Outer Join B b On (a.id =b.id)
This means all record from table A will be displayed even if there's not a matching record in Table B.
Now if I want a right Outer Join betwee A and B, then instead of using a Right Outer Join I can get the same result using the below query
B b Left Outer Join A a On (b.id =a.id).
So why there's a need of right Outer join, if the same can be achieved using a Left Outer Join?
that's a good question
Originally Posted by alirulez999