Learning SQL --集合操作

Learning SQL --集合操作
A+B  A  union B 
AB   A  intersect B
A-B   A except B
1.union intersect except
SELECT id,gender
FROM student_list
UNION ALL
SELECT id,food
FROM favorite_food;


UNION 去除重复项，union保留重复项