简单版的SELECTa.CreateBy,Name=stuff((select','+NameFROMSG_ClientWHERECreateBy=a.CreateByforxmlpath('')),1,1,'')FROMSG_Clientagroupbya.CreateBy //连表查询SELECTa.Co...