stupid question :)

  • Thread starter Thread starter DM
  • Start date Start date
D

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.
 
SELECT Table2.*
FROM Table2
LEFT JOIN Table1
WHERE Table1.ClientID Is Null

HTH
Van T. Dinh
MVP (Access)
 
Back
Top