MDAC 2.5 SDK - ODBC Desktop Database Drivers


 

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'