SQL: Full outer join?

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 Mon Jul 02 2001 - 22:20:39 CDT