>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.
SELECT * FROM firsttable ;
WHERE keyfield ;
NOT IN (SELECT keyfield FROM secondtable) ;
INTO CURSOR mylist