select CONCAT( "", a.demographic_no, "" ) AS "DemoLink", a.provider_no as Doctor, dm.last_name as Lastname, dm.first_name as Firstname,
CONCAT(prov.first_name, " ", prov.last_name) as ListedDoctor,
CONCAT( "",dm.email, "") AS "Email Link"
FROM appointment a, demographic dm, provider prov, clinic c
WHERE
a.demographic_no = dm.demographic_no
AND a.appointment_date >= '{start}' and a.appointment_date <= '{finish}'
AND a.provider_no = prov.provider_no
AND
(
("{provider}" = "ALL")
OR
("{provider}" = ohip_no)
)
GROUP BY a.demographic_no
ORDER BY Lastname;
( SELECT ohip_no, CONCAT(first_name,' ',last_name,'(',ohip_no,')') AS name
FROM provider where provider_type='doctor' and status=1 and ohip_no!='')
UNION
( SELECT 'ALL', ' All providers' )
ORDER BY name ;