SQL: beware of NULL in WHERE NOT IN

SQL: beware of NULL in WHERE NOT IN

SQL: beware of NULL in WHERE NOT IN If you have ever written some SQL you are probably aware of the special status of NULL in SQL. To refresh your mind: NULL indicates absence of a value. You cannot use NULL in a comparison, it will always result in NULL. If this does...