Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello!
I have two tables, A and B. In the table B there some of the IDs of the
table A. How can i make a query to select all the record in the table A which
IDs are not also in table B?
Thanks very much.
 
Use the query wizard to create Unmatch records in Table A that are not in
Table B

Somethin like
SELECT A.*
FROM A LEFT JOIN B ON A.ID = B.ID
WHERE B.ID Is Null
 
Back
Top