will have
- a row for each appointment in the given range
- a row for each patient who doesn't have an appointment
Then the where clause throws away the ones with appointments.
regards,
Bill
> From: "lorenzo.kh" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED
Hi,
I have 2 tables.patientrecall_table
and appointment_table.The patientrecall_table used to store what is the
nextrecall date for the patient while the appointment_tablewill store
all the appointments made.Now, I'd like to get through this:"Patients
Due for Recall, but No Scheduled Appo
