Select results that are not in both tables.

[nminaker]

I have two tables: One master list of all the items that a user can select and a list of the items the user has selected.

When I load the master list I want to select only the items that don't exist in the user list.

Thanks!

Nick

 

[JarlH]

Perhaps something like:
[tt]
SELECT item FROM masterlist
WHERE item NOT IN (SELECT item FROM userlist)[/tt]

 

[PHV]

Another way:
SELECT M.item
FROM masterlist M LEFT JOIN userlist U ON M.item = U.item
WHERE U.item IS NULL

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

 

[nminaker]

Thanks! Works great. I guess I need to work on my sql skills a little. It seems so simple now...