A script-enabled browser is required for this page to function properly.

Creating a nested condition (Query Builder)

To create a nested condition:

  1. In the Query window, in the Condition field, type the first expression using a comparison operator, such as: TOTAL<1000.  Note:  When you select a column object from a table, Query Builder automatically uses the table alias in your query.  Likewise, if you include a column object in the Condition field and accept the condition, Query Builder automatically inserts the appropriate table aliases into your condition.
  2. Type the next expression, using another comparison operator, such as: EMP.LAST_NAME=SMITH
  3. Type a third expression, using the same comparison operator (=), such as: EMP.LAST_NAME=JONES.
  4. Select the second and third expressions.
  5. Click the OR button in the Icon Bar.
  6. Click the Accept button in the Icon Bar.

See also

About conditions (Query Builder)

 

Adding conditions to a query (Query Builder)

 

Condition syntax (Query Builder)

 

Controlling join conditions in linked queries (Query Builder)

 

Creating a negating condition (Query Builder)

 

Pasting a function (Query Builder)