Re: Problem with outer join
From: Srini Sunderarajan <ou79019_at_deere.com>
Date: 1996/01/18
Message-ID: <DLE88A.J72_at_deere.com>#1/1
Date: 1996/01/18
Message-ID: <DLE88A.J72_at_deere.com>#1/1
Try This:
select B.keyid, nvl(sum(value),0)
from A, B
where B.keyid = A.keyId (+)
and nvl(tdate,'18-JAN-95') = '18-JAN-95'
group by b.keyid;
...Srini (OU79019_at_deere.com) Received on Thu Jan 18 1996 - 00:00:00 CET