The best way to find this information is to create constituent queries to find ticket buyers for each program. For example, we'll create a query for Ticket Buyers for Program 1, another query for Ticket Buyers for Program 2, then combine them into a third query that contains the constituents that exist in both. If you try to do this in one query, you'll only see constituents returned in your results that purchased tickets to both programs on the same sales order. 

Part 1: Create a Query for Ticket Buyers to Program 1
  1. Go to Analysis > Information Library
  2. Click Add an Ad-hoc Query 
  3. Select a Constituents Source View and click OK. 
  4. The New ad-hoc query screen will appear. From the left column (Browse for fields in), expand the Sales Orders node, then expand Sales Order Item, then expand Sales Order Item Ticket. 
    1. Option 1: To find ticket buyers for a specific program event (for example, the Guided Tour on February 12th at 2pm), in the left column beneath Sales Order Item Ticket, highlight Program Events. From the middle column, drag Program Event Record to Include Records Where and search for the program event you need to find purchasers for. Image of Program Event Record field
    2. Option 2: To find ticket buyers for a specific program (for example, the Guided Tour on any date), in the left column beneath Sales Order Item Ticket, highlight Program. From the middle column, drag Program Record to Include Records Where and search for the program record you need to find purchasers for. Image of Program Record field
  5. (Optional) If you would only like to include patrons that still have Active tickets on their order (i.e. the tickets have not been refunded and added back to inventory), in the left hand column beneath Sales Order Item Ticket, highlight Tickets. From the middle column, drag Status to Include Records Where and set this to be equal to Active. Your field will appear like this: Sales Orders\Sales Order Item\Sales Order Item Ticket\Tickets\Status is equal to Active.
  6. On the Set save options tab, name your query and check the boxes to Save as a selection and to Show this selection in the Query Designer. Boxes to check
  7. Click Save and close.
Part 2: Create a Query for Ticket Buyers to Program 2
  1. Repeat Steps 1-7 in Part 1 for Program 2. Hint: You can also copy the query from Program 1 and edit the Program Event or Program Record. 
  2. If you'd like to compare purchasers to more than 2 programs, you can also repeat these steps for any remaining programs. 
Part 3: Combine the Queries
  1. Go to Analysis > Information Library 
  2. Click Add an Ad-hoc Query
  3. Select the source view of Constituents and click OK 
  4. From the left column (Browse for fields in), highlight the Selections folder. From the middle column, find your selection for Ticket Buyers to Program 1 and drag it to Include Records Where. Set the criteria to be equal to Yes. 
  5. From the middle column, find your selection for Ticket Buyers to Program 2 and drag it to Include Records where also. Set the criteria to be equal to Yes.
  6. Repeat this process for any remaining selections you would like to include. Your query criteria should look similar to this:
Final Criteria Example
  1. Add any fields you'd like to display about these constituents to Results fields to display 
  2. Save your query to access later. If you are using your query in a mailing process, be sure to also mark the box to create a selection.