Merge all rows without deduplication.
Section: EXISTS and Set Operations
Combine result sets with UNION ALL
sql
sql
SELECT event_type FROM web_events
UNION ALL
SELECT event_type FROM mobile_events;Explanation
UNION ALL is usually faster than UNION because it skips duplicate elimination.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing EXISTS and Set Operations
Combine result sets with UNION
Merge distinct rows from two compatible queries.
Subtract rows with EXCEPT
Return rows from the first query not present in the second.