Query

H

Henry

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.
 
O

Ofer Cohen

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
 
Top