由于系统集成,别的系统需要我提供一个组里面包含的成员。
稍微查询下,得到如下SQL:
select b.Title,c.tp_Login,c.tp_Title from
WSS_Content.dbo.GroupMembership as a
inner join WSS_Content.dbo.Groups as b
on a.GroupId = b.ID
inner join WSS_Content.dbo.UserInfo as c
on a.MemberId = c.tp_ID
由于系统集成,别的系统需要我提供一个组里面包含的成员。
稍微查询下,得到如下SQL:
select b.Title,c.tp_Login,c.tp_Title from
WSS_Content.dbo.GroupMembership as a
inner join WSS_Content.dbo.Groups as b
on a.GroupId = b.ID
inner join WSS_Content.dbo.UserInfo as c
on a.MemberId = c.tp_ID
转载于:https://www.cnblogs.com/olay/archive/2013/01/08/2851902.html