Set operations
SQL
Set operations in SQL is a type of operations which allow the results of multiple queries to be combined into a single result set.
Set operators in SQL include UNION, INTERSECT, and EXCEPT, which mathematically correspond to the concepts of union,... Wikipedia