SELECT DISTINCT provider_no, CONCAT(last_name,', ',first_name,' (',provider_no,')') AS name FROM provider WHERE status = 1 ORDER BY name ; SELECT d.first_name AS 'First Name', d.last_name AS 'Last Name', d.hin AS 'PHN', CONCAT(d.year_of_birth, '-', d.month_of_birth, '-', d.date_of_birth) AS 'Date of Birth' FROM demographic d WHERE d.patient_status = 'AC' AND d.provider_no = {provider_no} ;