Chapter 6: New Features in SQL Server Release 11.0
Subquery
changes
The behavior of certain subqueries has changed. See “Changes that may affect existing applications” for detailed
information about these changes and how they may affect your existing
applications.