SELECT Fields from Table1 WHERE KeyField NOT IN (SELECT KeyField FROM Table2)
>Hi
>
>Table1 is related to Table2.
>
>I want to run a SELECT on Table1 and only obtain records that DO NOT have a related record in Table2.
>
>Can anyone help me on this.
>Thanks
>Kev
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer