Is it possible to have a nested query where the nested query 'excludes' the record that is needed in the main query?
All patient's that are in IP with financial classes NX, FL, SC and exclude patient's that are in TX and MP and in financial classes in NX, BL, TN,OK.
This is what I thought would work, but doesn't??
Select patient type, financial class
Where patient type = IP
and financial class = NX,FL,SC
and patient type not in (select patient type
where patient type in('tx','mp') and financial class in ('nx','bl','tn','ok'))