Re: Conditional Join

From: NitsR <nitinvraj_at_gmail.com>
Date: Wed, 21 Nov 2007 22:04:51 -0800 (PST)
Message-ID: <4982b23a-1540-4158-b576-e86fab3afa81@e23g2000prf.googlegroups.com>

this one seems to work

SELECT mascustomer.customercode, mascustomer.customername,

       (SELECT mascustaddr.custaddr
          FROM mascustaddr
         WHERE mascustomer.customerid = mascustaddr.customerid
           AND activeyn = 'Y') as addr

  FROM mascustomer Received on Thu Nov 22 2007 - 00:04:51 CST