USING Clause - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database

USING Clause

 

Syntax Element …

Specifies …

USING

Keyword to introduce the clause.

name (value)

One or more name-value pairs.

name (scalar_subquery)

You can also specify a subquery that returns a single row. Only one subquery is allowed for each name. The subquery must return only one row and the WHERE clause of the subquery must reference a unique primary index or unique secondary index. The row can have multiple values (columns) but all values must be the same data type.