select distinct de.demographic_no as "Demograhic Number",
de.last_name, de.first_name,
de.year_of_birth,
CONCAT( "/", de.demographic_no, "/" ) AS "DemoLink"
from demographic de where de.provider_no = "{provider_no}" and de.year_of_birth >= "{Earliest}" and de.year_of_birth <= "{Latest}" and de.sex like "{sex}%" and de.patient_status = "AC" order by de.last_name;
( select distinct provider_no, concat(last_name,',',first_name,'(',provider_no,')') as name
from provider where provider_type = 'doctor' and status = 1 )
UNION
( select 'ALL', ' All providers' )
order by name ;