Next: The Result Relation
Up: Query-by-Example (QBE)
Previous: Queries on Several Relations
When it is difficult or impossible to express all constraints on the
domain variables within the skeleton tables, the condition box
may be used.
To add the constraint that we are only interested in customers other
than Jones to the above query, we include the condition box:
To find all account numbers with balances between $1,300 and $1,500:
Logical expressions and and or may appear in the condition box.
To find all account numbers where the balance is between $1,300 and $2,000,
but is not $1,500:
An unconventional use of the or construct allows comparison with
several constant values:
Tue Jun 9 14:17:04 PDT 1998