andy vandenberghe wrote:
> 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
UNION between two outer joins...
Received on Tue Mar 02 2004 - 18:49:49 CST
