FROM

Use a FROM clause to specify the data objects or subquery from which the selected values are stored or derived.

Compass queries may include data from more than one data object. See query functionality for JOIN and Subqueries for information.