WHERE Details

Database Guide : Database Help : Database windows and dialogs : SQL clause editors : WHERE Details

WHERE Details

Use the WHERE Details window to specify one of the following:

• The WHERE clause of a SELECT statement

• The WHERE clause of an UPDATE statement

• The WHERE clause of a DELETE statement

You can also use this window to add expressions to the left and right operand lists. This is helpful when the WHERE clause you want to use consists of multiple expressions.

Note:

The WHERE clause will be removed from the SQL statement if you specify an empty expression and then select Apply.

Fields

• Left operand

• Operator

• Right operand

• Expression

Menu-bar choices

• Unary operator

Push buttons

• Select Apply to accept the WHERE clause and close the window.

• Select Add to operand lists to add the expression you have specified to the left and right operand lists.

Tasks

• Specifying a WHERE clause

Opening WHERE Details

You can get to the WHERE Details window from one of the following windows:

• SELECT Details

1. Make sure you have selected the tables and views you want to include in the FROM clause of the SELECT statement.

2. From the Clause pull-down menu, select WHERE.

• UPDATE Details

1. Make sure you have selected the table or view you want to use in the SQL statement.

2. Select WHERE clause.

• DELETE Details

1. Make sure you have selected the table or view you want to use in the SQL statement.

2. Select WHERE clause.

Last modified date: 01/29/2015