This identifies the archived table from which data is retrieved for the query results. Generally, the columns in the projection list are, or are based on, columns from this table.

This is an alias for the archived table or subquery (nested table expression), used to identify the database object in qualified column references within the SELECT statement. A correlation name is optional for an archived table, since the actual name can be used to qualify column references. However, a correlation name is required for a subquery, which cannot be referenced in any other way.

Note that, in addition to requiring a correlation name, each subquery must be contained entirely in parentheses.