Corel wordperfect office 2002 Manuel D’Utilisation
Saving queries
Paradox lets you save your queries so that you can use them again. Saving a query is particularly
useful in the case of complicated queries. By re-running a saved query, you ensure that the same
selection conditions are used each time you want to retrieve data from your tables.
To save a query
1 Click File } Save.
2 Choose the drive and folder where you want to save the file.
3 Type the query name in the File name box.
2 Choose the drive and folder where you want to save the file.
3 Type the query name in the File name box.
Creating multi-table BE queries
Paradox lets you retrieve data from two or more tables by allowing you to create multi-table
queries. In this way, a multi-table query is similar to a multi-table form or report. If you have
already created a data model for the purpose of creating a form or report, you can base your
multi-table query on the same data model. For more information on creating data models, see
“Creating a data model” on page 364.
The following image illustrates tables that are joined under a common field.
The following image illustrates tables that are joined under a common field.
To create a multi-table query
1 Click File } New } Query.
2 Choose the drive and folder where the table is stored.
3 Hold down CTRL and select the tables you want to query.
4 Click Open.
5 Click Query } Join table.
6 Click the common field in each of the tables.
7 Enable the check boxes for each of the fields you want to include in the Answer table.
8 Click Query } Run query.
2 Choose the drive and folder where the table is stored.
3 Hold down CTRL and select the tables you want to query.
4 Click Open.
5 Click Query } Join table.
6 Click the common field in each of the tables.
7 Enable the check boxes for each of the fields you want to include in the Answer table.
8 Click Query } Run query.
For more information on including query fields, see “Using Query By Example” on
page 377.
Working with queries
379