13.2.9.8 Subqueries in the FROM Clause - MySQL

MySQL 5.0 Reference Manual :: 13 SQL Statement Syntax :: 13.2 Data Manipulation Statements :: 13.2.9 ... Subqueries are legal in a SELECT statement's FROM clause. ... Any columns in the subquery select list must have unique names.

dev.mysql.com