Re: Full join on Oracle?

Tsk tsk tsk....

Unless I'm getting this wrong, he wants to know the syntax to a full OUTER join. Otherwise, what other definiton of FULL JOIN is there?

Here's how to do a FULL OUTER JOIN in Oracle:

SELECT a.whatevercolumns, b.whatevercolumns FROM
   A,
   B
WHERE
   B.somekey(+) = A.somekey
UNION
SELECT a.whatevercolumns, b.whatevercolumns FROM
   A,
   B
WHERE
   A.somekey(+) = B.somekey AND
   A.somekey IS NULL

There ya go.

JP

ed.prochak_at_alltel.com (Ed prochak) wrote in message news:<e51b160.0206110919.620fdf1d_at_posting.google.com>...
> 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
Received on Wed Jun 12 2002 - 14:52:55 CEST