> select count(1) from snapshotlist where id not in (select id from q);> count> -------> 0> (1 row)
Doesn't this usually happen if q.id contains NULL. That is as per ANSI standard.