>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