User`s guide

Fine-Tuning Queries Using Advanced Query Options
5-49
1
Load basic.qry.
2
Set the Data return format Preference to cellarray and Read NULL numbers
as to NaN.
3
Click Where in Advanced query options.
The WHERE Clauses dialog box appears.
4
Click Subquery.
The Subquery dialog box appears.
5
In Tables, select productTable, which includes the association between the stock
number and the product description. The fields in that table appear.
6
In Fields, select stockNumber, the field that is common to this table and the table
from which you are retrieving results.