O'Reilly logo
  • Dustin Waybright thinks this is interesting:

There are a number of ways to address this problem, but probably the most natural is to use an interesting capability in the language—separate some of the joins to their own independent logical phase.


Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012


An INNER JOIN in the left to right execution logic can eliminate rows that were preserved in an earlier OUTER JOIN.