Set Operators

Set operators: UNION, INTERSECT, and EXCEPT, help combine or compare query results. Example: This merges patients from both lists. 💡 Future clinical idea: Use INTERSECT to identify patients who are both in a high-risk med list and have a recent adverse event record.