sql 基础

[yangfanlei]

表a
spid
1
2
3
表b
spid
4
5
6
显示的结果为
1
2
3
4
5
6
不知道这样可不可以？？？

[dawugui]

select * from a
union
select * from b

[bill024]

select spid from a
union
select spid from b

[-狙击手-]

select   spid   from   a 
union 
select   spid   from   b

[hui_hui_2007]

select * from a
union
select * from b

[yangfanlei]

谢谢，但怎么给分？？

[tim_spac]

点击管理帖子，给分，结贴

[hui_hui_2007]

乱插空格的bug修改无期呀。