SELECT
CONCAT( "" ,
dm.demographic_no, "" ) As "Dem#",
CONCAT( "" ,
ef.fdid, "" ) As "fdid",
ef.form_name As "eForm_name",
ef.form_date as "Date",
ef.form_provider as "Provider",
dm.last_name "Last",
dm.first_name "First",
dm.sex AS "G",
CONCAT(dm.year_of_birth,'-',dm.month_of_birth,'-',dm.date_of_birth) AS "DOB"
FROM demographic dm, eform_data ef
WHERE
dm.demographic_no = ef.demographic_no
AND
ef.form_name LIKE "%{eformname}%"
AND
ef.form_date >= "{eform_date}"
Order by ef.form_date desc;