MySQL Query the Physical Exams for a patient

(Ralf Lukner MD PhD) #1

How do I MySQL query to display the physical exams for a particular patient?
Thanks in advance,

(Stephen Waite) #2

hi @Ralf_Lukner, how about
SELECT f.*, fpe.* FROM forms as f LEFT JOIN form_physical_exam as fpe on fpe.forms_id = f.form_id WHERE = ? and formdir = "physical_exam"