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,
–Ralf


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