還有一種方法，但要在表中加入一個字段才可以實現。。。。
表t_test
id name orderid
1001 aa 1
1001 bb 2
1001 cc 3
1005 aa 1
1005 bb 2
1005 cc 3
1005 dd 4

SELECT k.id, isnull(A.name,'')+','+isnull(B.name,'')+','+isnull(C.name,'') as name
FROM
(SELECT DISTINCT id FROM t_test ) AS k
left JOIN
(Select id, name From t_test Where Orderid = 1 ) AS A
ON k.id = A.id
LEFT JOIN
(Select id, name From t_test Where Orderid = 2 ) AS B
ON k.id = B.id
LEFT JOIN
(Select id, name From t_test Where Orderid =3 ) AS C
ON k.id = C.id
....................
LEFT JOIN
(Select id, name From t_test Where Orderid =n ) AS n
ON k.id = n.id

[此贴子已经被作者于2007-9-11 20:49:29编辑过]

刚学,看不太懂.
如果 这样做
那如果id号为1001的有5000.有50000.有5000000000
那不写死?

[此贴子已经被作者于2007-9-11 20:53:16编辑过]

你们刚学就这么厉害啊，我都管SQL4年了，连你们写的什么意思都看不懂，诶

是啊。。就是這裡不太好，還需進一步修改

[此贴子已经被作者于2007-9-12 8:52:43编辑过]

棉花糖.
kendy123456
这两个高手都不来了.

http://bbs.bc-cn.net/viewthread.php?tid=120669&star=at#
看看这个吧

看不懂.

楼上谦虚了

没有.数据库确实初学.菜鸟一名.

if object_id('fn_合并') is not null drop function fn_合并
go
create function fn_合并(
@id varchar(20)
)
returns varchar(300)
as
begin
declare @r varchar(300)
set @r=''
select @r=@r+' '+ tm from tablename where id=@id
return @r
return @r=stuff(@r,1,1,'')

end
go
--调用
select id,dbo.fn_合并(id) as tm from tablename
group by id
drop function fn_合并
drop table tablename
这样吧...................