union/union all运算:将查询的返回组合成一个结果, union all不过滤重复。
SELECT product_id FROM order_items
UNION
SELECT product_id FROM inventories;
SELECT location_id FROM locations
UNION ALL
SELECT location_id FROM departments;
intersect运算:返回查询结果中相同的部分。
SELECT product_id FROM inventories
INTERSECT
SELECT product_id FROM order_items;
SELECT product_id FROM inventories
MINUS
SELECT product_id FROM order_items;