Combine the result
Combine the result from multiple SELECT statements into a single result set.
SELECT 10 AS a
UNION
SELECT 20;
| a |
*
10
20
Example
SELECT City FROM Customers
UNION
SELECT City FROM Suppliers
ORDER BY City;
https://www.w3schools.com/sql/sql_union.asp
