SELECT SG.Id ,SG.GroupName ,HostNames = STUFF((SELECT ',' +SH.[HostName] FROM SaltHost SH WHERESG.Id= SH.HostGroupId FORXML PATH(''), TYPE).value('.','NVARCHAR(MAX)'),1,1,'')FROM [SaltGroup] SGORDER BYSG.Id
来源: