What is the difference between left outer join and right outer join. Which one is better.
I know the basic difference wherein for left outer join all rows of table in left are selected and compared whereas in case of right outer join all rows of table in right are selected and compared.
But besides that what difference it has I am not aware of it. Also I am not sure which one is better over the other.