Re: Conditional Join

Hi John

thanks for the reply
I am using 10g

I changed my query as per your suggestion as follows

SELECT a.customercode, a.custname, b.custaddr   FROM mascustomer a RIGHT OUTER JOIN mascustaddr b

       ON (a.customerid = b.customerid)
 WHERE (b.activeyn = 'Y')

Still the same result, only matching records are returned. Received on Wed Nov 21 2007 - 22:10:28 CST