Creating a WHERE Clause

A WHERE clause filters (limits) the records that you will select with a SQL statement. [Picture]

1. There are 2 different approaches to creating a WHERE clause.

1. Directly enter the SQL into the WHERE Clause text box. Optionally, click the Insert button to select functions, field names, and operators.

2. Click Add New Condition to display the Add New Condition dialog. [Picture]

3. If this is the second or subsequent component of the WHERE clause, select "AND" or "OR" from the list box at top.

4. Pick a field from the Select a column list box.

5. Select an operator.

6. Depending on the operator selected, select one or more additional arguments.

7. Optionally, click Insert argument to use a previously defined argument instead of a constant value.

8. Click OK to save your inputs.

2. Optionally, click Preview Records to see how the WHERE clause will affect your SQL SELECT statement.

3. When finished, click OK to save your inputs and return to the calling dialog.

See Also

Enterprise Reporting

Supported By

Alpha Five Version 7 and Above (Requires Enterprise Reporting License)