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

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

From

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

Note

Versus aliasing the alias into a relational table.