Joins on NULL column is not distinct from
If you choose a nullable column in a join clause, offer the use IS NOT DISTINCT FROM in SQL Server 2022 and above in addition to =
This would assist in (and alert the user to the fact that they were trying to) join between two columns where you may wish to treat NULL as equal.
1
vote