求一sql语句?

[wxb168]

表 t1:

字段 a
1
2

表 t2:

字段 b
3
4

怎么得到 t1 和 t2 字段 a 和 b的全部内容:


1
2
3
4
谢谢了哈...

[bridge05]

select t1.a from t1
union all
select t2.b from t2

[kk19840210]

create table #t1(id int)

create table #t2(id int)

insert into #t1 values(1)

insert into #t1 values(2)

insert into #t2 values(3)

insert into #t2 values(4)

select id from #t1
union all
select id from #t2


id
-----------
1
2
3
4

[pigengler]

union all

[pt1314917]

select a [ ] from t1
union all
select b [ ] from t2

[zhouchunyu]

可以是交叉连接实现，如楼上

[planebus]

SELECT * FROM t1
UNION
SELECT * FROM t2