ACCESS / AQL

and clause

The and clause is used between selection criteria clauses to indicate that both condition being evaluated as true selects the item for processing.

Syntax

with clause and with clause

Example(s)

This example lists those items that meet one of two criteria: a name starting with ar and with a city starting with irv, or, a city starting with san and a contact containing the string joe.

list entity with name "ar]" and with city "irv]" or with city "san]"
and with contact "[joe]"

See also

or clause→Relational operators and logical clauses→

Referenced by

6 topics mention and clause in its description.

Index utilization in selection criteria Modifiers select command Selection criteria String searching & logical operator