select DISTINCT b.DynamicID,STUFF((//stuff是截取第一个逗号
select ','+ a.RealName from
(
select z.DynamicID,u.RealName from t_Dynamic_Zambia z
left join t_sys_User u on z.UserID=u.ID
)a where a.DynamicID=b.DynamicID
for xml path('')//关键语句,以xml的格式输出
),1,1,'') as namelist
from
(
select z.DynamicID,u.RealName from t_Dynamic_Zambia z
left join t_sys_User u on z.UserID=u.ID
)b
表a和b可以换成单表来测试,