Anti-Join
An anti-join finds rows with no match on the other side — customers who never ordered. One NULL can make NOT IN return nothing; NOT EXISTS does not.
An anti-join finds rows with no match on the other side — customers who never ordered. One NULL can make NOT IN return nothing; NOT EXISTS does not.