两个表的数据整合导出的问题

[qqok]

town shopID cName
长安 CHA001 李四

pShopID phoneCOde
CHA001 5678941
CHA001 5678942
CHA001 5678943
CHA001 5678944
有什么方法可以把这些数据导出到EXCEL,显示结果为:


town shopID cName phoneCOde
长安 CHA001 李四 5678941,567892,5678943,5678944

[zarge]

create function dbo.f_getphonecode( @pshopid varchar(10) )
returns varchar(1000)
as
begin
declare @str varchar(1000)
select @str = ''
select @str = @str + pshopID + ',' from tab2 where pshopid = @pshopid
return @str
end

select t1.town, t1.shopid, t1.cname, dbo.f_getphonecode( t1.shopid ) as phonecode
from tab1

[qqok]

我试试.先谢啦.

[qqok]

function dbo.f_getphonecode 是什么?是怎么用的.