sql group 拼接字段

 

 

SELECT m1.ID,m1.ProduceDate,m1.TypeFlag,m1.[LineNo],m2.LineName,


 STUFF(( SELECT  ',' + cast(ms.[ID]  as varchar)+':'+ cast(ms.PlanAmount  as varchar)  --需要组合的字段
                FROM    t_PrdctPlanDatail ms --需要遍历的表
                WHERE   PrdctPlanId = m1.ID --关联条件
                FOR
                XML PATH('')
                ), 1, 1, '') AS 明细 
 from t_PrdctPlans m1

INNER JOIN m_Lines m2 on m1.[LineNo]=m2.[LineNo]


WHERE m1.ProduceDate='2022-01-11'
GROUP BY m1.ID,m1.ProduceDate,m1.TypeFlag,m1.[LineNo],m2.LineName --分组