Using Both And and Or

Multiple With clauses can also be connected together with a combination of And and Or. In this case, the command processes the With clauses from left to right, tying together the clauses connected with And, and separating them from those connected by an Or. In other words, And has a higher priority than Or.For example, the command:

List CUSTOMERS With STATUS = 'A' Or With STATUS = 'P' And With CITY = 'LOS ANGELES'

will find all customers whose status is "active" or those whose status is "potential" and who also live in Los Angeles. Customers whose status is "potential" but who do not live in Los Angeles will be ignored.

Each clause separated by an Or is treated as a completely different selection criterion. In the above command, customers will be selected either if they are active, or if they are potential and live in Los Angeles. The clauses linked with an And are treated as a single unit ¾ each individual clause within the unit connected by And must be true for the linked clauses as a whole to be true.