This query will find all the customers who work in France or London.
If you have more than one condition, and each condition applies to a different field, you still use the or cells for each field in your condition.
For example, you want to find customers who work in either France or London. Because France is in the Country field and London is in the City field, you need to enter the criteria under their respective fields.
You could type "France" in the Criteria cell under the Country field, and "London" in the or cell under the City field, as shown on the left.