User`s guide

Fine-Tuning Queries Using Advanced Query Options
5-53
1
Set the Data return format preference to cellarray and the Read NULL
numbers as preference to NaN.
2
For Data operation, click Select.
3
For Data source, select dbtoolboxdemo.
The Catalog, Schema, and Tables for dbtoolboxdemo appear.
Do not specify Catalog or Schema.
4
In Tables, select the tables from which you want to retrieve data. For this example,
press Ctrl+click and select both productTable and salesVolume.
The fields (columns) in those tables appear in Fields. Field names appear in the
format tableName.fieldName. Therefore, productTable.stockNumber indicates
the stock number in the product table and salesVolume.StockNumber indicates
the stock number in the sales volume table.
5
In Fields, press Ctrl+click to select the following fields:
• productTable.productDescription
• salesVolume.January
• salesVolume.February
• salesVolume.March
6
In this example, the Where clause equates the productTable.stockNumber with
the salesVolume.StockNumber, so that product description is associated with
sales volumes in the query results.
In Advanced query options, click Where to associate fields from different tables.
The WHERE Clauses dialog box appears.
7
In the WHERE clauses dialog box:
a
In Fields, select productTable.stockNumber.
b
For Condition, select Relation.
c
In the drop-down list to the right of Relation, select =.
d
In the field to the right of the drop-down list, enter
salesVolume.StockNumber.
e
Click Apply.
The clause appears in the Current clauses field.