User`s guide

Fine-Tuning Queries Using Advanced Query Options
5-47
• To delete a clause, Select the clause from Current clauses and click Delete. Use
Ctrl+click or Shift+click to select multiple clauses.
7
Specify a subquery in the HAVING Clauses dialog box, as needed. For details, see
“Creating Subqueries for Values from Multiple Tables” on page 5-48.
8
Click OK.
The HAVING Clauses dialog box closes. The SQL statement in the Visual Query
Builder dialog box updates to reflect the specified having clause.
Example: Using Having Clauses
This example restricts the results from basic_where.qry to sales greater than 2000 for
January and February:
1
In Advanced query options, click Having. The HAVING Clauses dialog box
appears.
2
For January:
a
Select > as the Relation Condition.
b
Enter 2000 as the Relation value.
c
Select the AND Operator.
d
Click Apply.
3
For February:
a
Select > as the Relation Condition.
b
Enter 2000 as the Relation value.
c
Click Apply. The HAVING Clauses dialog box appears as follows.