17.10 - Rules for Columns Not Associated With an Explicit Table Name - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

If a column is not associated with an explicit table name, tables named in the SQL statement are searched, and one of the following occurs.

IF this … IS … THEN …
a matching column found in only one table the requested information is returned.
found in two or more tables an ambiguous column name error is reported.
not found the NAMED list is searched for the column name.

Named names are not valid when used to fully qualify a table name.

a column name not found in the SQL statement or in the NAMED list a nonexistent column error is reported.