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'