The prompted view of a query
You can build simple to complex queries using the prompted
query interface. Select New --> Query,
then View --> Prompted to start building
a query using the prompted query interface. The Prompted query interface
has five sections where you specify the elements of your query.
The five sections are:
- Tables where you specify the tables that will be used
in the query.
- Join Conditions where you specify the join conditions
for tables, if you are using multiple tables in the query.
- Columns where you specify what columns will be included
in the query results
- Sort Conditions where you specify how the rows in the
query results will be sorted.
- Row Conditions where you can specify conditions that
will limit the rows that are returned in the query results.
In each section you can add, edit, delete and move through the
entries using the icons located for each in the upper right hand
corner.
