Merge Two Queries

You can merge two queries together to create a new query. For example, if you want to send your organization's Annual Report to your constituents and you already mailed this information to your Board of Directors, you can create a query for your mailing using merging operators to exclude your Board of Directors from your mailing list. The records included in the resulting query are determined by the merging operator you select. To help you visualize the queries and how their records relate to one another, the program provides a Venn diagram to represent each merge option. When you build a merged query, you select the merge option to use based on the records to include in the new query.

Note: A Venn diagram depicts two circles — one for each selection used to build the merged query— that overlap in the middle. The middle section of the diagram, where the circles overlap, represents the records that appear in both queries. The outer sections represent the records that appear in each respective query but not the other.

Create a merged query from two queries

 

 

You are here: Overview > Need Help with Analysis? > Information Library > Ad-Hoc Queries > Merge Queries