FROM Clause

Following the SELECT clause, the FROM clause specifies where to search for matching documents. Locations for which a query returns results, and the function used to specify the location, are referred to as the "scope" of the search.

The top-level syntax of the FROM clause is:

FROM <unqualified_scope> | 
<qualified_scope> |
<union_all_scope>

Three types of scope specification are supported. An unqualified scope searches in the default search catalog, and a qualified scope specifies which single catalog to search. Use a UNION_ALL scope when searching in more than one catalog.

This section includes the following topic:

• Scope Specifications

Related Topics

General Query Language Information

SELECT Statement

WHERE Clause

UNION ALL Scope Specifications