How You Can Define a Query
The first step in defining a query is to access the Query Editor. In the Query Editor, you must select the tables you want to include in your query.
The Query Editor's Edit menu also provides two commands that let you qualify table names:
• Add Schema to Query Table
• Remove Schema from Query Table
A Where Clause Editor can be accessed from the Query Editor, which lets you add where clause restrictions.
After tables are selected to include in the query and their master-detail status designated, you access the Join Definition dialog to specify table joins.
If you want, you can use the Sort Columns dialog to specify how you want rows of data ordered.
Each of these steps and procedures is described in the sections that follow.