sql 递归 STUFF 

select distinct fm_id,
STUFF((select distinct ISNULL( ',' +SO_Num,''  ) from [t_BADItems] it WHERE it.fm_id=its.fm_id for xml path('') ),1,1,'') AS SO_Nums 
 from [dbo].[t_BADItems] its

 表内一对多 的关系查询

posted @ 2015-11-11 17:21  yufeiyunsui  阅读(167)  评论(0)  编辑  收藏  举报