SQLite Forum

Find rows not in other sub query?
Login
Chronological Hierarchical 
Perhaps:

        SELECT zip FROM zip WHERE zip.zip NOT IN (SELECT main.zip FROM main);

to find any rows in table "zip" that have no counterpart in table "main".