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.

From

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

Note

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