A derived table is constructed by evaluating a table expression over the columns and values of the base table set. The semantics of derived tables correspond to those of views. A view is similar to a named derived table.
Derived tables allow you to specify a spool file composed of selected data from the base table set supporting the table expression in the FROM list of a query.
For information about derived tables, see Teradata Vantage™ SQL Data Manipulation Language , B035-1146 .