Re: SQL: Full outer join?

From: Sanjay Mishra <oraskm_at_yahoo.com>
Date: 10 Jul 2001 10:14:10 -0700
Message-ID: <eca56b4a.0107100914.778008da@posting.google.com>

The UNION is the best thing you can do with Oracle8i to solve this problem. Oracle9i has a new syntax for full outer joins, which is the ANSI standard.

select A.*, B.*
from A FULL OUTER JOIN B
ON A.pk = B.pk

HTH,
Sanjay

onlyforposting_at_yahoo.com (Vikas Agnihotri) wrote in message news:<77e87b58.0107021920.287b3c03_at_posting.google.com>...
> How can I write a SQL for the following 2-table join?
>
> Based on the PK, Table A has 0 or 1 matching values. Table B has 0 or
> 1 matching values.
>
> i.e. where A.pk = B.pk(+) or B.pk = A.pk (+)
>
> Is the above valid? Or do I need
>
> select... where a.pk=b.pk(+)
> union
> select .... where b.pk=a.pk(+)
>
> Any other efficient approaches?
>
> Thanks
Received on Tue Jul 10 2001 - 12:14:10 CDT