SELECT CONCAT( "" , dm.demographic_no, "" ) As "Dem#", CONCAT( "" , ef.fdid, "" ) As "fdid", ef.form_name As "eForm_name", ef.form_date, 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;