Need help with query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two patient tables. One has patients with a certain condition, and
the other has patients with a different codes. Some patients have both
conditions (so they will appear in both tables), and I want to find those
patients who are only in the first table and not the second table. I ran a
make-table query that shows patients who have both conditions, but I can't
figure out how to run a query to show only the patients who are in table one
but not table two. Anyone have any suggestions?

Thanks!
 
Back
Top