sql union
-- UNION: distinct values (slower) SELECT emp_name AS name from employees UNION SELECT cust_name AS name from customers; -- UNION ALL: keeps duplicates (faster) SELECT emp_name AS name from employees UNION ALL SELECT cust_name AS name from customers;