SQLite Forum

Mismatch in query results
Excellent! Thank you very much. I need to get more familiar with SQL obviously.

sqlite> select cds.* from cds where genre like '%jazz%'
   ...> EXCEPT
   ...> select cds.* from cds inner join artists on artists.artistid=cds.artistid and cds.genre like "%jazz%";
20801|1697|1|Long Ago And Far Away|1:11:49||Jazz
20915|1759|1|Water From An Ancient Well (1985)|0:46:46||Jazz

I'm missing those 2 artistid's.