select ProjectName, STUFF(( SELECT ', ' + u.UserName + '(' + cd.CodeName + ')' FROM tbProjectManPower mp LEFT OUTER JOIN vwUser u on mp.UserID = u.UserID and u.LanguageCode='ko-KR' LEFT OUTER JOIN tbSYSCode cd on cd.MainCode='PROJECT.Position' and mp.ProjectPosition = cd.SubCode WHERE mp.ProjectSeq = p.ProjectSeq FOR XML PATH('') ),1,1,'') AS UserName from tbProjectInfo p where p.ProjectSeq = 3