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

Adding conditions to a query (Query Builder)

To add conditions to a query:

  1. In the Query window, click in the blank condition field in the Conditions panel.
  2. In the Data Source panel, select the column (either select the check box next to the column, or double-click the column name) to which you want to apply a condition. To display a list of all available columns, click the Paste Column button in the Icon bar to display the Paste Column dialog box. 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.
  3. Add the appropriate operator (comparison, arithmetic, or logical)to your condition.
  4. To add functions to your condition, click the Paste Function button in the Icon bar.
  5. Type or select a column for the appropriate value for the right side of your condition expression after the operator.
  6. To add another condition, press Shift-Enter to move the cursor to a new line.
  7. If you’re satisfied with your expression, click outside the condition field but within the Conditions panel to deactivate it, or click the Accept button in the Icon bar.

Clearing the Conditions panel

See also

About conditions (Query Builder)

 

Condition syntax (Query Builder)

 

Controlling join conditions in linked queries (Query Builder)

 

Creating a negating condition (Query Builder)

 

Creating a nested condition (Query Builder)

 

Pasting a function (Query Builder)