Re: Full Outer Joins possible?

select *
from table_b,

        table_a
where table_a.id = table_b.id(+)
union
select *
from table_a,

        table_b
where table_b.id = table_a.id(+)
order by 1;

Ken Rachynski wrote:

> I'm trying to figure out if the following is possible. I can do it
> with other servers.
> I am trying to join two tables such that I get all of the records in
> table A that have matching data in table B, plus all of the records in
> Table A without matching data in table B, plus all of the records in
> table B without matching data in Table A. Can this be done?
> Table A
> id data_a
> 1 1
> 2 2
> 5 3
> Table B
> id data_b
> 2 1
> 3 2
> 4 3
> 5 4
> Result
> id data_a data_b
> 1 1 NULL
> 2 2 1
> 3 NULL 2
> 4 NULL 3
> 5 3 4
Received on Tue Aug 10 1999 - 06:48:01 CDT