At 15:16 09/03/2016, you wrote: > select id from a where id not in (select a.id from b);
Shouldn't the engine bark on this, like it does on the modified version: select id from a where id not in (select zzz.id from b); "no such column zzz.id" As I understand it, there is no more an a.id column in table b. It looks like SQLite is trying to get clever ignoring the "a." qualifier.