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.