Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Problem with outer join
Hi,
This is due to the fact that when a.cus1bo is null, you do not have a row, so a.addrno is null, so join on a.addrno = ca.addrno fails, so query fails.
Jacques
"Kram" <kram_at_biosys.net> wrote in message
news:395BD639.C01CE35C_at_biosys.net...
> I have a problem with an outer join (doesn't seem to work). Can anybody
> help me with this piece of code? The Cus1no field is sometimes NULL.
>
> SELECT
> a.adno,a.vno,a.runno,a.cus1name,a.cus2no,a.cus2name,a.cus2tel,a.addrno
>
,a.caller,a.adrname,s.salno,a.cus4tel,a.startdate,a.enddate,a.cus4name,a.mul
conflag,a.ad_type,a.pubcnt,a.boxno,a.boxtype,a.ratecode,a.agreement,a.unet,a
.rdate,a.checkads1,a.checkads2,a.checkads3,a.remarks,a.changereason,c.custyp e,c.cgrno,c.acusno,ca.address1,ca.address2,ca.address3,ca.state,