对于sql 99 ANSI模式是表可以有一个别名 的AS
关键字,这样,就可以拍摄出AS
它应该在每一个RDBMS工作。在小提琴上看到它:
在ISO / IEC 9075-2:1999的 7.6 节 < 表参考>中,第232页:
<table reference> ::=
<table primary>
| <joined table>
<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> ]
| <only spec>
[ [ AS ] <correlation name>
[ <left paren> <derived column list> <right paren> ] ]
| <left paren> <joined table> <right paren>
还确认可以正常工作: