MDAC 2.5 SDK - ODBC Desktop Database Drivers
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'