Re: Outer Join

From: <maniapp_at_gmail.com>
Date: 20 Nov 2006 22:06:51 -0800
Message-ID: <1164089211.886582.145340@b28g2000cwb.googlegroups.com>

Hi Bala,

Try this, though i am not sure whether i am fully understanding your req. I guess the following should work to whatever i understood.

 SELECT tblHeader.HCode,

                tblHeader.HName,
                tblHeader.HMisc,
                (Select tblProg.ProgName
                  FROM tblProg
                 WHERE tblProg.ProgCode = NVL(tblHeader.HProgCOne,
tblHeader.HProgCTwo)
                  AND tblProg.ProgFilter IN (3,9)
                )ProgName

FROM tblHeader;

Just confirm whether it did work fine.

Thanks
Mani Received on Tue Nov 21 2006 - 00:06:51 CST