A derived table is an intermediate table, dynamically produced as the result of a SELECT subquery in the FROM clause of a SELECT query. The following sections detail limitations.

For more information about derived tables and their syntax, see the Ingres SQL Reference Guide and the Enterprise Access OpenSQL Reference Guide.