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 Florida AND Maryland?
No—a customer can't be in two places at once.
Do I want to find customers with a state of either Florida OR Maryland?
That makes sense, so this query would use the OR operator.
-
In the Ribbon, click Run.
The query results should look like this:
