Recordset1 not equal to Recordset2 2

[Deenuts]

I have two tables namely:

Recordset1 - Primary Key UserID
Recordset2 - Primary Key UserID

I need to select records from Recordset1 where UserID is not equal to UserID in Recordset2.

I have tried to execute this query using <> operator but it does not run. I have also tried !=.

At one point the query returned results where UserID is the same.

 

[PHV]

A starting point (SQL code):

SELECT A.*
FROM Recordset1 A LEFT JOIN Recordset2 B ON A.UserID = B.UserID
WHERE B.UserID IS NULL

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[randy700]

Have a look at the Unmatched Query Wizard.


Randy