Return Unequal Fields

[Stefan]

I have two queries

query#1 (Patients with remaining visits)
query#2 (Patients Scheduled)

I would like to have a query return the values (patients)
that are in query#1 but not contained in query#2
(scheduled).

What is the best way to accomplish this?

Thanks in advance

 

[tina]

the easiest way (for those of us who aren't great at SQL)
is to create a new (third) query using the "Find Unmatched
Query Wizard". what you described is exactly what it's
for, and it'll walk you right thru the process. just go to
the Queries tab in the database window, click on New (or
press Alt+n) and select the wizard in the dialog box, then
follow the instructions on the screen....

hth