SQLite Forum

Find rows not in other sub query?
Login
Hello,

Is there a way in SQLite to display only the rows that aren't in a sub-query?

I need to investigte why the following queries don't return the same number of rows:

<code>select count(*) from main;
5854
</code>

<code>select count(*) from main,zip where main.ZIP=zip.ZIP;
5905
</code>

Thank you.