How do I write sql code that takes a list of items from one table and compares them to a list in another table and gives a list of items of the first table that found no matches? Thanks for the Help.
Its called a sub query.....
SELECT *;
From table1;
Where listitem1 not in (select * from table2)
I don't know what your list of items in so I can't help you much more than that. But that's how you do a subquery. That query will get all listitem1's that are not in table2
Hope I helped
Brent Knight
Progressive Impressions International
Bloomington, IL
Wise men talk because they have something to say; fools, because they have to say something.
-Plato