>I have 2 Tables
>(1)Customer - CustCode,.......
>(2)CustTrans - CustCode, CaseClosed (boolean),.......
> (will have multiple records of same CustCode)
>
>I would like to get all rows from the Customer table, but
>exclude those rows that the CustCode is found in the CustTrans
>table AND with the CaseClosed status is "False".
>
>How should my SQL statement be like, pls advise, thanks.
Select *
FROM Customer LEFT OUTER JOIN CustTrans
ON Customer.CustCode = CustTrans.CustCode
WHERE CustTrans.CaseClosed = True
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com