|
Syntax Element … |
Specifies … |
|
(subquery) |
nested SELECT expressions. You can specify NORMALIZE in a subquery. You cannot specify SELECT AND CONSUME statements in a subquery. You cannot specify an EXPAND ON clause in a subquery. |
|
AS |
an optional introductory clause to the derived table name. |
|
derived_table_name |
the name of the derived table. |
|
column_name |
a list of column names or expressions listed in the subquery. Enables referencing subquery columns by name. Note: Specify column names only. Do not use forms such as table_name.column_name or database_name.table_name.column_name. If specified, the number of names in the list must match the number of columns in the RETURNS TABLE clause of the CREATE FUNCTION statement that installed the function_name table function on the Teradata platform. The alternate names list corresponds positionally to the corresponding column names in the RETURNS TABLE clause. If omitted, the names are the same as the column names in the RETURNS TABLE clause of the CREATE FUNCTION request that installed the function_name table function on the Teradata platform. |