日期:2014-05-19  浏览次数:20563 次

sql如何把结果放到一行里面去
select   'a '   as   a  
select   'b '   as   b
如何得到
[a][b]
  a     b
就是把结果放到一行里面去


------解决方案--------------------

select * from
(select 'a ' as a )a
CROSS join
(select 'b ' as b)b