| title |
Correlation Names | Microsoft Docs |
| ms.custom |
|
| ms.date |
01/19/2017 |
| ms.prod |
sql |
| ms.prod_service |
connectivity |
| ms.reviewer |
|
| ms.technology |
connectivity |
| ms.topic |
conceptual |
| helpviewer_keywords |
correlation names [ODBC] |
SQL grammar [ODBC], correlation names |
|
| ms.assetid |
76c36c6f-f8e1-4ece-a77b-611dde3bdd8a |
| author |
MightyPen |
| ms.author |
genemi |
| manager |
craigg |
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'