22,210
社区成员
发帖
与我相关
我的任务
分享
create table a(id int,a int,a1 int)
insert into a values(1 ,1, 1)
insert into a values(2 ,2, 2)
insert into a values(3 ,3, 3)
create table b(id int,b int,b1 int)
insert into b values(4 ,4 ,4)
insert into b values(5 ,5 ,5)
insert into b values(6 ,6 ,6)
go
select id , c = a , d = a1 from a
union all
select id , c = b , d = b1 from b
drop table a , b
/*
id c d
----------- ----------- -----------
1 1 1
2 2 2
3 3 3
4 4 4
5 5 5
6 6 6
(所影响的行数为 6 行)
*/
如果要去重复的:
select * from a
union
select * from b
select * from a
union all
select * from b