SQLite Forum

Mismatch in query results
Login
Pretty simple direct translation:

```
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%";    
```

or directly from an English problem statement:

```
select * from cds where genre like '%jazz%' and artistid not in (select artistid from artists);
```