TIP: The two common Boolean operators are AND and OR. They're easily confused. If you don't know which to use, ask yourself the purpose of the query:
Do I want to find customers with a state of both Virginia AND New York?
No—a customer can't be in two places at once.
Do I want to find customers with a state of either Virginia OR New York?
That makes sense, so this query would use the OR operator.
-
Click the
icon.
The query results should look like this:
