Matching fields in databases 1

[NFLDUser]

I have a table called PatientList with a field called prim_key representing each patient. I also have a table called Recalls with a field called pat_num. Is there a query that will tell me what patients in PatientList do NOT have a recall associated with them?

 

[Lilliabeth]

Replace PatientName with whatever your patient name field is called.

SELECT PatientList.PatientName, Recalls.pat_num
FROM PatientList LEFT JOIN Recalls ON PatientList.prim_key = Recalls.pat_num
WHERE (((Recalls.pat_num) Is Null));

 

[NFLDUser]

Thanks!