01表的加法–union
会合并两个表,并且去除重复部分–并集
SELECT product_id,product_name
FROM PRODUCT
UNION
SELECT product_id,product_name
FROM product3
02包含重复项–all
SELECT product_id,product_name
FROM PRODUCT
UNION ALL
SELECT product_id,product_name
FROM product3
03选出两个表中公共部分–intersect
SELECT product_id,product_name
FROM PRODUCT
INTERSECT
SELECT product_id,product_name
FROM product3
04记录的减法–except
上减下留下剩余的
SELECT product_id,product_name
FROM PRODUCT
EXCEPT
SELECT product_id,product_name
FROM product3