UNION ALL

A set operation combining compatible query results while retaining duplicate rows.

What is UNION ALL in a relational database?

UNION ALL — A set operation combining compatible query results while retaining duplicate rows.

SELECT email FROM customer
UNION ALL
SELECT email FROM supplier;

Level: Apprentice · More Database terms at this level

Updated