databasessql
Nulls can change a SQL anti-join
Anonymous
If a subquery used by not in returns a null, a nonmatching value can evaluate to unknown rather than true, so a where clause drops it. not exists avoids that particular null behavior, but check whether null keys should match under the intended logic.
0