SELECT CONCAT(DATE_FORMAT(a.appointment_date, '%Y-%m-%d '), TIME_FORMAT(a.start_time, '%h:%i %p')) AS "Appointment Date/Time", a.name AS "Patient", a.reason AS "Reason",
CONCAT(
'',
'eChart',
''
) AS "eChart",
(
CONCAT(
'',
'Bill',
''
)
) AS "Bill $"
FROM appointment a
LEFT JOIN billing b ON a.appointment_no = b.appointment_no
WHERE b.appointment_no IS NULL
AND a.demographic_no > 0
AND a.appointment_date BETWEEN '{date_from}' AND '{date_to}'
AND a.provider_no = '{provider_no}'
AND a.status NOT IN ('N', 'C', 'B')
ORDER BY a.appointment_date;
SELECT provider_no, concat(last_name,', ',first_name,'(',provider_no,')') from provider
WHERE status='1'
AND provider_type='doctor'
AND ohip_no>1
ORDER BY provider_no;