Re: SQL: Full outer join?

write

select a.*, b.*
from (select a.* from a, b where a.pk (+) = b.pk) a, b where a.pk = b.pk (+)

Another option would be

select a.*, b.*
from a, b, (select a.pk from a union select b.pk from b) c where c.pk = a.pk (+)
and c.pk = b.pk (+)

Which is fastest?

Martin

Vikas Agnihotri wrote:
>
> 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 Sat Jul 21 2001 - 16:23:27 CDT