R
Rob M
Hi all,
I have a question about a small medical clinic database.
The database has a table with basic demographic info (name, address, birth
date, etc.). There are also two subtables. Subtable 1 contains referrals
for that patient. Subtable 2 contains appointments for that patient.
Therefore, for each patient, there can be multiple referrals, and within
each referral, there can be multiple appointments.
I'm trying to create a query that lists demographic info + the most recent
referral only + the most recent appointment only.
Does anyone know how this can be done?
Many thanks,
Rob
I have a question about a small medical clinic database.
The database has a table with basic demographic info (name, address, birth
date, etc.). There are also two subtables. Subtable 1 contains referrals
for that patient. Subtable 2 contains appointments for that patient.
Therefore, for each patient, there can be multiple referrals, and within
each referral, there can be multiple appointments.
I'm trying to create a query that lists demographic info + the most recent
referral only + the most recent appointment only.
Does anyone know how this can be done?
Many thanks,
Rob