Using AS
The AS keyword is available before correlation names, and after the following:
Nested table expressions
Table names
View names
Aliases
Synonyms
Parent topic:
Correlation Names