full outer join in oracle 8.1.7 ?

From: andy vandenberghe <hp275_removethis_at_skynet.be_removethis>
Date: Tue, 02 Mar 2004 23:55:19 +0100
Message-ID: <hp275_removethis-2A9713.23551902032004@news.skynet.be>

hi,

i'm trying the following query on Oracle 8.1.7

select a.im, a.p1, b.p2
from
(select dim2 as im, amount as p1 from aagirep2a where period='200302'
and dim1='700000') a,
(select dim2 as im, amount as p2 from aagirep2a where period='200402'
and dim1='700000') b
where a.im=b.im (+)

this takes all rows in a even if there's no match in b (right join) but i want also the rows in b with no match in a (left join)

How do i do that ? I cannot do a full outer join in Oracle 8.1.7 afaik

Regards,
Andy Received on Tue Mar 02 2004 - 16:55:19 CST