这个union all 怎么写

[nettt]

我有两笔完全不同数据，

A表查询数据列是 a1,a2,a3

B表查询数据列是 B1,b2,b3

如何把数据整理显示成 a1,a2,a3,B1,b2,b3

在线等

[xuam]

select * from A,B

[renolit]

select * from a
union all
select * from b

[fengxiaohan211]

顶楼上两位

[yibey]

select * , null as b1,null as b2,null as b3 from A
union all
select null as a1,null as a2,null as a3,* from B

[luochaowei1987]

select * from A,B where ...

[以学习为目的]

declare @tb1  table(col1 char(2),col2 char(2),col3 char(2))
insert into @tb1
select 'a1','a2','a3' 

declare @tb2  table(col1 char(2),col2 char(2),col3 char(2))
insert into @tb2
select 'B1','b2','b3' 

select *  from @tb1,@tb2

/*
col1   col2    col3    col1    col2    col3
a1	a2	a3	B1	b2	b3

*/

[以学习为目的]

[Quote=引用 2 楼 的回复:]

SQL code
select * from a
union all
select * from b
[/Quote]

这种union all效果是

declare @tb1  table(col1 char(2),col2 char(2),col3 char(2))
insert into @tb1
select 'a1','a2','a3' 

declare @tb2  table(col1 char(2),col2 char(2),col3 char(2))
insert into @tb2
select 'B1','b2','b3' 

select *  from @tb1
union all
select  *  from @tb2

/*
col1   col2    col3
a1	a2	a3	
B1	b2	b3
*/

[renolit]

[Quote=引用 6 楼 的回复:]
SQL code
declare @tb1 table(col1 char(2),col2 char(2),col3 char(2))
insert into @tb1
select 'a1','a2','a3'

declare @tb2 table(col1 char(2),col2 char(2),col3 char(2))
insert into @tb2
select……
[/Quote]
我的失误，多谢指出