Correlation Names
Correlation names are fully supported, including within the table list. For example, in the following string, E1 is the correlation name for the table named Emp:
SELECT * FROM Emp E1
WHERE E1.LastName = 'Smith'
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Correlation names are fully supported, including within the table list. For example, in the following string, E1 is the correlation name for the table named Emp:
SELECT * FROM Emp E1
WHERE E1.LastName = 'Smith'