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 TABLE 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 and Outer Joins.