MySQL SQL

MySQL UNION ALL

Combine SELECT results while keeping duplicates.

SELECT email FROM customers
UNION ALL
SELECT email FROM subscribers;

UNION ALL usually avoids duplicate-removal work, but the result may contain repeated rows.