UNION

Database Dictionary -> UNION

UNION

The UNION clause merges the results of two or more queries into a single result set, which contains all the rows resulting from all queries in the union.

SQL Tutorial