Query looking for no match between tables

[TonyB]

Hi,
I have two tables tblA, tblB both with an ID field. I want a query to select
records from A where there is no record in tblB with
a matching ID field ? How do I go about designing this ?

Regards
Tony

 

[Dan Artuso]

Hi,
Something like this:

SELECT tblA.* FROM tblA LEFT JOIN tblB ON tblA.id = tblB.id
WHERE tblB.id Is Null;

 

[TonyB]

Hi Dan,
Thanks, that worked great.
Tony

Hi,
Something like this:

SELECT tblA.* FROM tblA LEFT JOIN tblB ON tblA.id = tblB.id
WHERE tblB.id Is Null;