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 ;