05 版本以上可以用 XML select Table1.*
,stuff((select ','+RoleId from Table2 where Table2.UserId=Table1.UserId for xml path('')),1,1,'') RoleIds
from Table1
,stuff((select ','+RoleId from Table2 where Table2.UserId=Table1.UserId for xml path('')),1,1,'') RoleIds
from Table1
还有其他办法吗 谢谢
转换一下就可以了,
cast(roleId as nvarchar(30)) as roleid