One NULL in the List and NOT IN Returns Nothing

· by · in

NOT IN and NOT EXISTS read like the same thing. Find the rows that are not in that other set. They agree until the other set contains a NULL, at which point NOT IN returns…