Merge Operators

To combine records when you merge queries, use these merge operators:

And

Includes records that exist in both queries.

Or

Includes records that exist in either query.

Xor

Includes records that exist in the primary or secondary query, but not both.

Sub

Includes records that exist only in the primary query. This operator subtracts records in the secondary query from the primary query. For example, you can create a merged query of donors who have given in the past but aren't alumni.

 

 

Example

You have two queries: one for South Carolina residents and another for alumni. The merged query results change based on the merger operator you select:

And — The merged query returns alumni, who love in South Carolina.

Or — The merged query returns all alumni, and all South Carolina residents.

Xor — The merged query returns South Carolina residents who aren't alumni, and alumni who don't live in South Carolina.

Sub — The merged query returns South Carolina residents who aren't alumni.