User`s guide

5 Using Visual Query Builder
5-50
The statement SELECT stockNumber FROM productTable is created in the SQL
subquery statement.
7
Limit the query to product descriptions that are Building Blocks.
a
In Fields in Subquery WHERE clauses, select productDescription.
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 'Building Blocks'.
e
Click Apply.
The clause appears in the Current subquery WHERE clauses field and is
added to the SQL subquery statement.
8
Click OK to close the Subquery dialog box.
9
In the WHERE Clauses dialog box, click Apply.