SQL UNION: Combining Result Sets From Multiple Queries
To use the UNION operator, you write the dividual SELECT statements and join them by the keyword UNION. The columns returned by the SELECT statements must have the same or convertible data type, size, and be the same order. The database system processes the query by executing two SELECT statements first.
DA: 12 PA: 8 MOZ Rank: 72