sql，求

[DAO]

表结构如图1，查询结果如图2

id	name			
1	a		name	corestr
1	b		 1	  abc
1	c		 2	  ab
2	a		 3	  a
2	b			
3	a			

[funnyone]

select id,replace(wm_concat(name),',','') as names
from table
group by id

[DAO]

[Quote=引用 2 楼 的回复:]

SQL code

select id,replace(wm_concat(name),',','') as names
from table
group by id
[/Quote]
膜拜中.........

[XBodhi.]

1.分组处理

2.最后 在相加。