Posted by Simon Hayes on 10/01/43 11:27

If you got no rows, is it possible that your subquery result included a
NULL? NOT IN combined with a NULL returns an empty set; NOT EXISTS
returns all the non-NULL values. Google for 'sql "not in vs not
exists"' or something similar and you'll find plenty of discussions
about this.

Simon

[Back to original message]