stupid question :)

[DM]

I have a stupid question ))
I have two tables (Table1 and Table2), with identical structure; each has
three columns: ClientID, ClientName, ClientBalance. What I need is a query
that will select those clients from Table2 that do not exist in Table1.
Can anyone help me?
Thanks.

 

[Van T. Dinh]

SELECT Table2.*
FROM Table2
LEFT JOIN Table1
WHERE Table1.ClientID Is Null

HTH
Van T. Dinh
MVP (Access)

 

[DM]

Thank you.

SELECT Table2.*
FROM Table2
LEFT JOIN Table1
WHERE Table1.ClientID Is Null

HTH
Van T. Dinh
MVP (Access)