Complex Query Filters
To understand how the AND, OR, UNION, INTERSECT, and MINUS operators work, it’s useful to review a bit of set theory. Figure 22-7 shows a Venn diagram with three sets of criteria: Year, State, and Product Lines.
Figure 22-7 Intersection of multiple filter criteria
When you add query filters to your query, the filters are joined by a default operator: AND. All conditions must be met for the query to return results. You can say this is the intersection, or solid triangle, in Figure 22-7, where all three sets of criteria are met. For example, if you set the conditions as shown in the following screen, the query will return information ...