Nrthugu

**Table Doctor**       

*ID        Name       Other Value*

1         Jane           X

2         John           Y

3         Jame           Z



**Table Patient**

*ID        Name         Other Value*

1         Mary           A

2         Mark           B

3         Mel            C



**Table Appointment**

*ID        PatientID      DoctorID  OtherValue*

1             1             1          X

2             3             2          Y



**Table Exam**

*ID         ExamName*

1         Blood Exam

2         Pregnant Exam



**Table RequestExam**

*ID    AppointmentID   ExamID*

1          1             1

2          2             2



**Table ResultExam**

*ID       RequestExamID      OtherValues*

1              1                XYZA

2              2                ABCD



**Table DoctorDecision**

*ID       ResultExamID       OtherValues*

1             1                 Qwerty

2             2                 Asdfgh

I would like to know If from the last table (Table DoctorDecision) can I get the patient and doctor names? How would be a select to make it? I'm trying to make some joins, but not sure If is possible to get the values from the first tables.

Example - How I would know the name of the doctor, patient name and exam name who has the ResultExamID = 1 in the last table?

This query should give you the information you want:

SELECT p.Name, d.Name, e.ExamName

FROM DoctorDecision dd

JOIN ResultExam re ON re.ID = dd.ResultExamID

JOIN RequestExam qe ON qe.ID = re.RequestExamID

JOIN Exam e ON e.ID = qe.ExamID

JOIN Appointment a ON a.ID = qe.AppointmentID

JOIN Patient p ON p.ID = a.PatientID

JOIN Doctor d ON d.ID = a.DoctorID

WHERE dd.ResultExamID = 1

Output (for your sample data)

Name    Name    ExamName

Mary    Jane    Blood Exam

Demo on SQLFiddle