摘要： 由于系统集成，别的系统需要我提供一个组里面包含的成员。稍微查询下，得到如下SQL：select b.Title,c.tp_Login,c.tp_Title fromWSS_Content.dbo.GroupMembership as ainner join WSS_Content.dbo.Groups as bon a.GroupId = b.IDinner join WSS_Content.dbo.UserInfo as con a.MemberId = c.tp_ID 阅读全文