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