AND is a logical connective used to specify multiple selection expressions. AND specifies that all conditions must be met for an item to be selected.
AND takes precedence over the OR connective when both appear in the same query. A maximum of nine AND clauses can be included in a single INFO/ACCESS query.
OR is assumed when a logical connective is not explicitly entered between two selection expressions.
Example
This example lists all MCCOYs who live in BERKELEY:
|
>LIST CUSTOMERS WITH LAST-NAME = "MCCOY" AND WITH CITY = "BERKELEY" LAST-NAME FIRST-NAME |
See Also