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