How do the set operators work?

You can use the UNION, INTERSECT, and MINUS set operators to combine multiple conditions in a filter.

  • The UNION operator returns cases found in either filter.
  • The INTERSECT operator returns only those cases that are found in each filter.
  • The MINUS operator returns cases that are found in either of the filters, but not in both filters.