Results 1 to 2 of 2

Thread: Database Query Problem??

  1. #1
    Join Date
    Dec 2008

    Database Query Problem??

    Hi i have got a database with the following tables below:

    Patient (PatientCode, PatientSurname, PatientFirstname, PatientSex, Age, PatientOccupation, PatientHeight, PatientWeight, PatientAddress)

    Doctor (DoctorCode, DoctorSurName, DoctorFirstName, DoctorPrivateAddress, MobileNo, Function)

    Operation (Operation Code, PatientCode, DoctorCode, Date, Time, Result, OperationType)

    Is_Seen_By (PatientCode, DoctorCode, Date, Time)

    Basically i am trying to design a query that will say allow me to find the surname of the patients that have been seen by at least one of the doctors that have seen patient "P26", I am not sure on what would be the most efficient way of doing this can any1 help? thanks

  2. #2
    Join Date
    Apr 2009
    Can you explain about operation tables datas.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts