/*练习题4.1
找出 product 和 product2 中售价高于 500 的商品的基本信息。*/
SELECT *
FROM product
WHERE sale_price>500
UNION
SELECT *
FROM `product2`
WHERE sale_price>500 ;
/*练习题4.2
借助对称差的实现方式, 求product和product2的交集。*/
SELECT *
FROM product
WHERE product_id IN(SELECT product_id FROM product2)
UNION
SELECT *
FROM product2
WHERE product_id IN(SELECT product_id FROM product );