When comparing the NULLs in the region column in the rows from the two sides, the INTERSECT operator considered them as equal.
- 4. Combining Sets
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
This is necessary or matching rows with the same NULL columns would be eliminated. This is different than the WHERE and ON clauses.
Share this highlighthttp://learning.oreilly.com/a/training-kit-exam/60162/