I even don't know how to title my problem or what to search to solve it so please don't mind me if I don't describe it properly.

I have 3 tables:

Patient(**id**, name, ....)

Examination(**id**, date, patient\_id\*, notes)

Diagnoses(**id**, diagnose)

ExaminationDijagnose(**id**, diagnose\_id\*, examination\_id\*)

So I want to make a query where is only one input parameter and that is ExaminationID (Primary Key). The result will be one row with columns 

(examination\_id, date, name, diagnoses(array), notes).

The diagnoses column will be an array based on a examination\_id foreign key.

So like this if examination id is 10
Diagnose:
1 - Flu
2 - High temperature

ExaminationDijagnose will be
1 , 1 , 10
1 , 2 , 10

I need output to look like this
1(ExaminationID), date, patient\_name(patient\_id\*), Array(Flu, High Temperature), notes)

That array is concatination, so diagnose period diagnose. "Flu, High Temperature, Fracture etc...

Sorry again if I described it badly.
Thanks