SELECT CONCAT( "", demographic_no, "" ) AS DemoLink, last_name as Surname, first_name as First, phone, Age, Result FROM (SELECT demographic.demographic_no,`last_name`,`first_name`,`phone`, YEAR(DATE(CONCAT(YEAR(CURDATE()),'-10-01')))-demographic.year_of_birth-(DATE_FORMAT(DATE(CONCAT(YEAR(CURDATE()),'-10-01')),'00-%m-%d') 'D' AND billing_on_item.service_date BETWEEN DATE(CONCAT(YEAR(CURDATE()),'-09-20')) AND NOW() ) AS Item WHERE billing_on_cheader1.id = Item.ch1_id AND billing_on_cheader1.status <> 'D' UNION SELECT appointment.demographic_no AS demo_no, appointment.`appointment_date` AS Result FROM appointment WHERE appointment_date > NOW() AND INSTR(appointment.reason,'flu')>1 ) AS temp GROUP BY demo_no ) As Flu_Shot ON Flu_Shot.demo_no = Patient.demographic_no order by surname ; SELECT "'%'" AS provider_no, 'all providers' AS provider UNION 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;