help?

SELECT a.patientID patientID,
MAX ( CASE c.text WHEN 'Name' THEN a.text ELSE NULL END) name,
MAX ( CASE c.text WHEN 'Date_of_Birth' THEN a.text ELSE NULL END ) dob,
MAX ( CASE c.text WHEN 'Social_Security_Number' THEN a.text ELSE NULL END) ssn,
MAX ( CASE c.text WHEN 'ID' THEN a.text ELSE NULL END) uid,
p.addedBy addedBy,
p.deletedBy deletedBy
FROM patient p
JOIN (  SELECT a2.*
    FROM answer a2
    JOIN question q2 ON a2.questionID=q2.id
    JOIN questionnaire qs2 ON q2.questionnaireID=qs2.id
    JOIN culture c2 ON c2.id=qs2.NameID AND c2.text='CODE_DD' AND c2.lang='en') a ON a.patientID=p.id
JOIN question q ON q.id=a.questionID
JOIN culture c ON c.id=q.cultureID
GROUP BY p.id