Set WHERE Conditions
In the Query Builder, you can use a Where condition to filter data returned by a query or to join sets of data.
Note: If you reverse engineer a query that contains a Where clause, it displays in a Global Where clause bubble on the Diagram pane rather than the Where Condition field below the Diagram pane. You can double-click the Global Where Clause bubble in the Diagram pane, or can click 
To set a Where condition
- In the Query Builder, add columns to the query. To learn more about the Query Builder, see Build Queries Visually.
- In the Criteria pane (bottom pane), select the column you want to use to filter data.
-
Select the Where field in the column and click
.
Note: You can also use the Where Condition to add the same column twice to the query.
-
Use the Where Condition editor to create a Where clause. Review the following for additional information:
Form Page Description Field
Select an operator or predicate to use in this condition.
Value 1 Type
(Value 2 Type)
Select whether the expression is a column or constant.
- Column—After selecting this option, select the column name.
- Constant—After selecting this option, enter a value or select a value from the list.
If using the IN or NOT IN operator, you can load multiple values from a .txt, Excel, or .csv file.
- Select Constant. Click
- After the file is uploaded, the values are automatically added to the Where clause. Click the down arrow to display the loaded values or to deselect some values.
Notes:
- You can also specify a bind variable in this field using ":variable". If you enter a variable, you are prompted to enter a value for the variable when you execute the statement.
- The Value 2 Type field is only available if you select the Between predicate.
Formula Page
Description
Functions
Perform an incremental search or select a function and then select a column on which to perform the function.
Note: The date format for functions is any valid date format supported by the database surrounded by single quotes (for example, 'mm/dd/yy').
Operators
Double-click an operator or predicate to use in this condition.
Columns and calculated fields
Double-click a column to apply a function or operator against.
Date Range Page
Description
Date Range Values
Select a date range to apply to this column. See Set Date Ranges for more information.
Note: This tab only displays if you select a column that has a Date data type.
Tips:
- You can use variables in a Where condition. See Using Bind Variables for more information.
- Click Subquery to add a subquery. See Add Subqueries for more information.
- To remove a Where condition, open the Where Condition window and click Remove.