EXCEL 2003两列数据合并问题，重分答谢！！！！

[xhb001]

A列 B列 C列

A 1 A1
B 2 A2
C 3 A3
B1
B2
B3
C1
C2
C3
如图 有A列和B列均为文本型，想得到C列的数据：即A和B分别合并，请问用哪个公式可以实现？？直接拖动成型最好。

[bancxc]

看来不够重

[dawugui]

select cast(a as varchar) + cast(b as varchar) from
(select a from tb) m,
(select b from tb) n

[dawugui]

create table tb(A varchar(10),B int)
insert into tb values('A' ,       1)
insert into tb values('B' ,       2)
insert into tb values('C' ,       3)
go

select a , b , c = cast(a as varchar) + cast(b as varchar) from
(select a from tb) m,
(select b from tb) n
order by a , b , c

drop table tb

/*
a          b           c                                                            
---------- ----------- ------------------------------------------------------------ 
A          1           A1
A          2           A2
A          3           A3
B          1           B1
B          2           B2
B          3           B3
C          1           C1
C          2           C2
C          3           C3

（所影响的行数为 9 行）

*/

[--小F--]

SQL的乌龟写了
EXCEL的帮顶下

[sych888]

[Quote=引用 2 楼 dawugui 的回复:]
SQL codeselectcast(aasvarchar)+cast(basvarchar)from
(select afrom tb) m,
(select bfrom tb) n
[/Quote]

up