UNION ALL

Applies to: sql

UNION ALL stacks query results without removing duplicates, so it is usually faster than UNION.

SELECT id FROM a
UNION ALL
SELECT id FROM b;

See also: union