union 查询语法: SELECT column_name(s) FROM table_name1 UNION SELECT column_name(s) FROM table_name2union all查询语法: SELECT column_name(s) FROM table_name1 UNION ALL SELECT column_name(s) FROM table_name2 union与union all的区别: 1.union可以组合多个SELECT,而union all只能组合两个SELECT 2.union查询不包含重复记录,union all可以包含重复结果 INTERSECT的语法:SELECT COLUMN1 [,COLUMN2] FROM TABLE1 [,TABLE2] [WHERE] INTERSECT SELECT COLUMN1 [,COLUMN2] FROM TABLE1 [,TABLE2][WHERE] INTERSECT查询相当于两个组合的交集,即R1∩R2。返回第一个SELECT与第二个SELECT语句里的一样的记录 EXCEPT的查询语法: SELECT COLUMN1 [,COLUMN2] FROM TABLE1 [,TABLE2] [WHERE] EXCEPT SELECT COLUMN1 [,COLUMN2] FROM TABLE1 [,TABLE2] [WHERE]EXCEPT查询相当于两个组合的差集A-B。返回返回第一个SELECT有与第二个SELECT语句里没有的记录