SELECT b.name +',' FROM
dbo.TechnologyColor a join [dbo].[CustomColor] b
on a.customcolorid=b.id
WHERE ProductId=345882800324677 FOR xml PATH('')
SELECT 需要合并的字段+',' FROM 表名 FOR XML PATH('')
标签：dbo,sqlserver,拼接,一列,PATH,SELECT From： https://www.cnblogs.com/friend/p/17680145.html