Combine result sets with UNION

sql

SELECT email FROM customers
UNION
SELECT email FROM leads;

Explanation

UNION removes duplicates. Use UNION ALL to preserve them.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing EXISTS and Set Operations

Merge all rows without deduplication.

Open In sheetsqlsame section

Return rows present in both queries.

Open In sheetsqlsame section

Return rows from the first query not present in the second.

Open In sheetsqlsame section

Return rows when a related row exists.

Open In sheetsqlsame section

Return rows with no related matches.

Open In sheetsqlsame section

Add extra conditions to the join itself.