/* UNION ALL is the same as union, but duplicate rows are NOT eliminated */
/* so if a student is also an instructor, 2 rows will appear in the result */

SELECT 'student', fname, lname 
from student
UNION ALL
SELECT 'instructor', fname, lname 
from instructor