SQLite Forum

Find rows not in other sub query?
Login
What I use mostly:

```
SELECT zip.* 
  FROM zip
  LEFT JOIN main ON main.ZIP = zip.ZIP
 WHERE main.ZIP IS NULL
;
```