​​​Creating complex queries​


There are 2 ways to combine queries and criteria to create more complex queries

Create a new query by Merging two queries together

This feature allows you to combine two existing queries.  e.g. "Which participants are in both queries?" or "Which participants are in Query A but not in Query B?".  

See How to merge two Queries

​Combine criteria using "OR"s  

By default the Query Builder requires that all of the criteria are true.  In some cases you may want some criteria to be combined using either/or,  e.g. "Participants who are either in HRT or are Hispanic"

See How to combine criteria using "OR" subgroups