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'
Den här webbläsaren stöds inte längre.
Uppgradera till Microsoft Edge och dra nytta av de senaste funktionerna och säkerhetsuppdateringarna, samt teknisk 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'