Can you guess what happens if you specify both the predicate that compares the supplier IDs from both sides and the one comparing the supplier country to Japan in the ON clause? Try it.
- 4. Combining Sets
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
Specifying Japan as a predicate in the ON clause does not filter rows from the table as it would in the WHERE clause for an OUTER JOIN, instead, it impacts matching. All left rows in this query are preserved.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/59533/