MySQL Query the Physical Exams for a patient

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

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 f.pid = ? and formdir = "physical_exam"

1 Like