Select this option to add a WHERE clause to your SQL select statement.  A WHERE clause allows you to specify search conditions for the select statement.  The search conditions determine which rows the select statement retrieves from the current database.

Use the construction steps more than once to add multiple search conditions to the WHERE clause.

Pressing OK in the Where dialog box adds the WHERE clause to the select statement.  The SQL Statement window displays the WHERE clause as part of the current SQL statement.

Where Dialog Box

Table:

The tables which you selected in the Select dialog box are listed.  Select a table to display its columns in the Column list box.

Column:

Select the column to be used in the search condition of the WHERE clause.

Operator:

Choose the comparison operator to be used in the search condition.

Comparison:

Select the Literal or Variable radio button to indicate the type for the second expression of the search condition of the WHERE clause.

If you choose to use a Literal value, you may type it, or use the List push button to bring up the Copy Value dialog box.

The Copy Value dialog box displays the distinct values for the column you have selected and allows you to copy one to the WHERE clause or to the clipboard.

If you choose to use a variable, a name for the variable is generated automatically, or you may type a name into the entry field.

Operator:

Choose a conjunction operator--AND, OR, or NOT--to join two search conditions in the WHERE clause.

Clause Options:

The WHERE clause is displayed here.

Use the Add button to add the search condition you have built to the WHERE clause.  The Add button may be used to build multiple search conditions into the WHERE clause.

Use the Remove button to remove portions of the WHERE clause, or the Clear All button to erase the entire WHERE clause.