Two NULL keys walk into a JOIN...

Question

Accepted Answer

JOIN conditions follow the same three-valued logic as WHERE. NULL = NULL is NULL, not true, so rows with NULL join keys never match. This is why INNER JOINs silently exclude rows with NULL foreign keys. If you need to match NULLs explicitly, you can use IS NOT DISTINCT FROM instead of =, which treats two NULLs as equal.