AS Derived Table Name
Syntax Element … |
Specifies … |
AS derived_table_name |
the name of a temporary derived table that other clauses in the SELECT statement can reference. AS is an introductory optional keyword for derived table. |
column_name |
an optional list of column names that other clauses in the SELECT statement can reference. 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 statement that installed the function_name table function on the Teradata platform. |