Usage Notes - Teradata Database

Uses for Derived Tables

Derived tables are an optional feature that you can specify in the FROM clause of SELECT, ABORT, ROLLBACK, and DELETE statements.

You can use derived tables for these purposes:

To avoid CREATE and DROP TABLE statements for storing retrieved information that is only needed for one request.

To enable you to code more sophisticated, complex join queries.

For examples, see “Inner Joins” on page 229 and “Outer Joins” on page 235.