SELECT first_name, last_name, 'Patient' as role FROM patients union all select first_name, last_name, 'Doctor' from doctors;