View tables and the query names of the WITH clause are called named derived tables.
When a named derived table is specified in a query specification, an internal work table may be created for the named derived table. A named derived table for which a work table is created is called an inner derived table.