AS Correlation Name - Teradata Database - Teradata Vantage NewSQL Engine
SQL Data Manipulation Language
- Product
- Teradata Database
- Teradata Vantage NewSQL Engine
- Release Number
- 16.20
- Published
- March 2019
- Language
- English (United States)
- Last Update
- 2019-05-03
- dita:mapPath
- fbo1512081269404.ditamap
- dita:ditavalPath
- TD_DBS_16_20_Update1.ditaval
- dita:id
- B035-1146
- lifecycle
- previous
- Product Category
- Teradata Vantage™
- AS
- Optional keyword introducing correlation_name.
- ANSI SQL refers to aliases as correlation names. They are also referred to as range variables.
- If you have multiple ON clauses, each correlation name used in the query must be unique.
- The correlation_name is an alias for the column that is referenced by column_name.
- For (column_name), you can specify one or more column names.
-
correlation_name
- An alias for the column that is referenced by column_name.
-
column_name
- One or more column names.