Re: Full join on Oracle?

brotherhou_at_yahoo.com (konghou) wrote in message news:<c19678a1.0206101821.1ebf95e2_at_posting.google.com>...
> Is there an equivalent of "full join in MS SQL" on Oracle?

Of course there is.

Oh, you want to know the syntax.

 You might try reading the ORACLE documentation, but just consider that ORACLE supports standard (ENTRY level) SQL:

SELECT <columns>
  FROM TableA, TableB
WHERE TableA.somecolumn = TableB.othercolumn  < AND/OR other conditions >
 ;

 HTH
   Ed

-- 
Edward J. Prochak   --- Magic Interface, Ltd.
Ofc: 440-498-3700
on the web at       --- http://www.magicinterface.com
email: ed.prochak_at_magicinterface.com