SELECT
CONCAT( "", e.fdid , "" ) as "fdid link",
e.form_date,
e.form_time,
e.subject,
CONCAT(p.provider_no, ' - ', p.last_name, ', ', p.first_name) AS form_provider,
CONCAT( "", e.demographic_no, "" ) as "demographic_no",
d.last_name,
d.first_name
FROM eform_data e
LEFT JOIN demographic d ON e.demographic_no = d.demographic_no
LEFT JOIN provider p ON e.form_provider = p.provider_no
WHERE e.fid = '{eform_id}'
ORDER BY e.form_date;
select fid, form_name
from eform
order by form_name ;