1. Create a constituent query for the main group of records needed (Query A)
  2. Create a second query for all of the records that need removed from the first group in Step 1 (Query B)
  3. Merge queries with Query A as the Primary Query and Query B as the Secondary Query
  4. Select the SUB operator
Merge Queries


Use Query List to remove specific constituent(s) from the query

Note: Both options will produce Static queries.