Andreas wrote:
> 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...
Or use an in-line view.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Tue Mar 02 2004 - 21:02:35 CST
