How to use SQL UNION operator to combine multiple SELECT statements into one result set

This article describes how to use the SQL UNION operator to combine multiple SELECT statements into one result set. Using UNION can greatly simplify the complex WHERE clause and simplify retrieving data from multiple tables.

Link to the original article: https://www.developerastrid.com/en/sql/sql-union/