select distinct concat( "", d.demographic_no, "" ) as 'Chart Number', CONCAT(d.last_name,', ', d.first_name) as 'Patient Name', CONCAT(date_of_birth, '-', month_of_birth, '-',year_of_birth, ' ') as 'Date of Birth', CONCAT(' Home: ', d.phone, ' Work: ' , d.phone2) as 'Phone Numbers' from demographic d, eChart e where e.Reminders like '%{searchtext}%' and patient_status = 'AC' and d.demographic_no = e.demographicNo order by last_name, first_name;