The NOT IN trap: why your SQL query returns zero rows

A query that returns an empty result is usually a wrong WHERE clause. But there is one class of empty...