I have a database that I need to write a report for. I have all the reports done but 1. I need a query that will allow me to get the information based on the following criteria.
I need to know what patients has had one procedure done but not another. They exists in the same field. How do I write a query that would allow me to find out who has had a shot but not a pill??