MichaelaLee
Programmer
Hi All,
I have the following tables:
Patients:
PatientId
Name
DoctorId
TheripistId
ect...
DoctorLookUp
KeyId
DoctorName
The doctor lookup table contains all doctors and Theripist in one table. Now I need to run a query that will display the name of the Doctor and Theripist when I query the Patients table. I've tried several things and can't seem to get it right. Could you please give me some examples that could work. Thanks for any help.
Michael Lee
I have the following tables:
Patients:
PatientId
Name
DoctorId
TheripistId
ect...
DoctorLookUp
KeyId
DoctorName
The doctor lookup table contains all doctors and Theripist in one table. Now I need to run a query that will display the name of the Doctor and Theripist when I query the Patients table. I've tried several things and can't seem to get it right. Could you please give me some examples that could work. Thanks for any help.
Michael Lee