How to find participants whose specimens belongs to 2 Carts

Since carts link to specimens, not directly to participants, the query returns a participant only if at least one specimen from that participant exists in carts.

Steps to create:

Create a new query to get specimens and participants from Cart #1, then save it.
Create another query to get specimens and participants from Cart #2, then save it.
Use these two saved queries as subqueries in another query. For more on subqueries, see page: Subquery.
Click on “View Records” and select columns to display information as per your requirements.