如何用SQL取岗位中的用户

图片：0630.png

如何用SQL取这些岗位中的用户，是哪个表与ot_user表关联的

查询ot_groupuser表，相关表说明你可以看一下数据库说明文档，说明文档在社区里可以搜索到

 --用户，姓名，，岗位及职务
 SELECT a.ObjectID AS PostID ,a.Code AS PostCode,a.Name AS PostName,a.PostRank,a.ParentID AS PostUnitID, c.ObjectID AS UserID, c.Name AS USerName,a.JobCode,d.DisplayName from dbo.OT_OrgPost a
  LEFT JOIN OT_GroupChild b  ON a.ObjectID=b.ParentObjectID
  LEFT JOIN dbo.OT_OrgJob d ON a.JobCode=d.Code
  LEFT JOIN dbo.OT_User c ON  b.ChildID=c.ObjectID
  WHERE 1=1   ORDER BY PostRank