UNION

Applies to: sql

UNION stacks query results and removes duplicates. The queries must return compatible columns.

SELECT email FROM leads
UNION
SELECT email FROM users;

See also: select, distinct