Example

SELECT name FROM employees UNION SELECT name FROM contractors;

UNION ALL

SELECT name FROM employees UNION ALL SELECT name FROM contractors;