This means that if you want to join multiple instances of the same derived table, you can’t. You have no choice but to duplicate the code
- 4. Combining Sets
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
Versus aliasing the alias into a relational table.