2.1.1.11 E051-09, Rename columns in the FROM clause

  • Article

V0011:

The specification states the following:

 Subclause 7.6, "<table reference>": 
  
 <table primary> ::=
 <table or query name> [ [ AS ] <correlation name>
 [ <left paren> <derived column list> <right paren> ] ]
 | <derived table> [ AS ] <correlation name>
 [ <left paren> <derived column list> <right paren> ]
 | <lateral derived table> [ AS ] <correlation name>
 [ <left paren> <derived column list> <right paren> ]
 | <collection derived table> [ AS ] <correlation name>
 [ <left paren> <derived column list> <right paren> ]
 | <table function derived table> [ AS ] <correlation name>
 [ <left paren> <derived column list> <right paren> ]
 | <only spec> [ [ AS ] <correlation name>
 [ <left paren> <derived column list> <right paren> ] ]
 | <parenthesized joined table>

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL partially supports this feature. Transact-SQL supports this feature only for derived tables.

See [ISO/IEC9075-1:2011] for the definition of "table".