Combining Multiple Criteria

When you specify multiple criteria in a query, you can combine them in the following ways:

• Both A AND B must be true
• Either A OR B must be true

You use Boolean operators (AND and OR) to specify the relationship between the criteria.

Using the AND Operator

Use the AND operator when you want two conditions to be true. For example, to get a list of male customers from the southwest, you specify the following query:

Gender: Male AND Region: Southwest

In this case, there are 70 males; there are 30 customers who live in the southwest, but only 10 males who live in the southwest.

Using the OR Operator

Use the OR operator when you want either of two conditions to be true. For example, to get a list of all the customers who are either male or from the southwest, you specify the following query:

Gender: Male OR Region: Southwest

In this case, there are 70 males; there are 30 customers who live in the southwest. 100 customers are either male or live in the southwest.

Note: Because 10 customers are both male and from the southwest, as indicated in the AND example, the audience list would contain 90 unique recipients after "de-duping" the 10 recipients who meet both criteria.