I want to compare 2 tables

[Kevin M.]

Hello Everyone,

I have table A that has a list of user id`s. Some of the
user Id`s are identical in table 2 and some of the user
id`s from table a are non existent in table 2. I want to
run a query that tells me what user id`s in table a are
non existent in table b

Thanks for any help!!

Kevin

 

[Lynn Trapp]

Run the Find Duplicates Query wizard

 

[Van T. Dinh]

A Left-Join Query should do. Something like:

SELECT TableA.UserID
FROM TableA
LEFT JOIN TableB
ON TableA.UserID = TableB.UserID
WHERE TableB.UserID Is Null