DB2 中union 用法

create table customer
(
id varchar(10) not null ,
name varchar(10),
company varchar(10),
address varchar(10),
code varchar(10)
)
insert into customer values('1','aa','aa','aaa','10')
insert into customer values('2','bb','bb','bbb','11')
insert into customer values('3','cc','cc','ccc','12')
insert into customer values('4','dd','dd','ddd','13')
insert into customer values('5','eee','ee','eee','14')
insert into customer values('6','ff','ff','fff','15')

create table emp
(
id varchar(10) not null ,
name varchar(10),
age varchar(10)
)
insert into emp values('1','aa','10')
insert into emp values('2','bb','11')
insert into emp values('7','as','23')
insert into emp values('8','bs','34')

select name from customer union select name from emp

union 显示所有记录重复记录将不显示(合并所有行)
select t.id from (select id, name from customer union   select id, name from emp order by id)as t  order by id

as 一定要不然抱错