ello all. Ive got an existing SQL query which I need to expand on. Currently I have 3 Tables Patient(PatientCode, PatientSurname, PatientFirstname), Doctor(DoctorCode, DoctorSurname, DoctorFirstName) and Operation(OpCode, PatientCode, DoctorCode, Date). What the current query I have does is find out the patient details of someone who had an operation on a certain date. But what I need it to do now is to get the patient details and doctor details. Any ideas on how to do this?? heres what I have on the original query so far
SELECT * From Patient Where PatientCode IN(SELECT PatientCode FROM Operation WHERE Date = '21/12/00');
Any help will be a big help!!
SELECT * From Patient Where PatientCode IN(SELECT PatientCode FROM Operation WHERE Date = '21/12/00');
Any help will be a big help!!