This content has been marked as final. Show 3 replies
I have a Patients table and Clinique Visits table.
Not all patients have visits records.
I’d like to add a flag to the Patients table
That represents when no visits exists for the relevant patients.
The following left join doesn’t work.
Left Join (Patients)
'No' as WithClnVisits
Resident [Clinique Visits]
Where not Exists (PatientID);
Any idea why?