union会对查询结果做一个并集:
1.sql Union用法
select 字段1 from 表名1 Union select 字段2 from 表名2;
2.sql Union All用法
select 字段1 from 表名1 Union all select 字段2 from 表名2;
select E_ID,E_Name FROM employees_china
union
select E_ID,E_Name FROM employees_usa
union all
select E_ID,E_Name FROM employees_china
union all
select E_ID,E_Name FROM employees_usa
当存在不相同的字段时: (employees_china 增加一个字段 E_Hello)
必须进行补充:
select E_ID,E_Name,E_Hello FROM employees_china
union all
select E_ID,E_Name,' ' as E_Hello FROM employees_usa