Combine the result
Combine the result from multiple SELECT statements into a single result set.
SELECT 10 AS a
<span class='keyword_code'>UNION</span>
SELECT 20;
| a |
*--
10
20
Example
SELECT City FROM Customers
<span class='keyword_code'>UNION</span>
SELECT City FROM Suppliers
ORDER BY City;
https://www.w3schools.com/sql/sql_union.asp
Last update: 221 days ago