Database Guide
Use the WHERE Details window to specify one of the
following:
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
Menu-bar choices
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
You can get to the WHERE Details window from one of the
following windows:
- SELECT Details
- Make sure you have selected the tables and views you want to include in
the FROM clause of the SELECT statement.
- From the Clause pull-down menu, select WHERE.
- UPDATE Details
- Make sure you have selected the table or view you want to use in the SQL
statement.
- Select WHERE clause.
- DELETE Details
- Make sure you have selected the table or view you want to use in the SQL
statement.
- Select WHERE clause.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]