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;