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

Note the importance of aliasing the tables in the join. For one, it’s convenient to refer to a table by using a shorter name. But in a self-join like ours, table aliasing is mandatory.


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


self-join is joining a table to itself.