UNION in MySQL

SELECT
  'advisor' as type,
  first_name,
  last_name
FROM advisor
UNION
SELECT
  'staff' as type,
  first_name,
  last_name
FROM staff;