I want to compare 2 tables

  • Thread starter Thread starter Kevin M.
  • Start date Start date
K

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
 
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
 
Back
Top