- Create a query, Query A, to include all the appropriate records
- Create a second query, Query B, of the records that should not be included. Ensure Query B is the same Query type is Query A. For example, if Query A is a constituent query, Query B must be a constituent query as well.
- Merge the queries using the SUB operator. Query A is the Primary query, and Query B is the Secondary query.
Connect and collaborate with fellow Blackbaud users.