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 4. Combining Sets from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012 by Dejan Sarka Itzik Ben-Gan and Ron Talmage Publisher: Microsoft Press Released: December 2012 Note An INNER JOIN in the left to right execution logic can eliminate rows that were preserved in an earlier OUTER JOIN. Share this highlight http://www.safaribooksonline.com/a/training-kit-exam/24090/ Twitter Facebook Google Plus Email Get Instant Access Now Start a Free Trial Have an account? Sign in. Minimise Unlock the rest of this book and 30,000 other books and videos By clicking this box, you confirm that you have read and agree to the terms and conditions of our Membership Agreement, and you understand that when your trial period ends, you will be required to provide billing information if you wish to continue using the service. Unlock the rest of this book Start a Free 10-Day Trial loading Learn about Safari for Business Have an account? Sign in.