Re: Difference in Left Join, Right Join

Ankur <ankurj_at_gmail.com> wrote:
> If we reverse the order of tables in a Left or Right Join we achieve
> the results of Right and Left Join.
>
> That is, a left join b is similar to b right join a.
>
> So, why do we have Left/Right Joins separately, instead of either one.

For convenience, I'd say.

Yours,
Laurenz Albe Received on Mon Jul 02 2007 - 09:13:56 CDT