UNION

A relational operator that combines all rows from two queries. A UNION B (A U B) returns all unique (distinct) rows from both A and B. UNION can only be applied to finite relations.