The code for Union.sql is: SELECT CONCAT(firstName, ' ', lastName) AS fullname, 'Employee' AS contactType FROM employees UNION SELECT CONCAT(contactFirstName, ' ', contactLastName), 'Customer' FROM customers #ORDER BY fullname #ORDER BY 2; # will order by contactType ORDER BY contactType DESC, fullname