Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Difference in Left Join, Right Join

Difference in Left Join, Right Join

From: Ankur <ankurj_at_gmail.com>
Date: Mon, 02 Jul 2007 12:49:42 -0000
Message-ID: <1183380582.857589.131680@k79g2000hse.googlegroups.com> 





Hi



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.



Thanks
Received on Mon Jul 02 2007 - 07:49:42 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US