S-HR查询用户组织范围 

SELECT org.FNumber FNumber,org.FName_L2 orgName 
FROM T_PM_OrgRange orgRange
LEFT JOIN T_ORG_admin org on orgRange.FORGID = org.FID
LEFT JOIN T_ORG_admin orgparent on  org.FParentID=orgparent.FID
LEFT JOIN T_PM_User u on u.FID=orgRange.FUserID
WHERE orgRange.FUserID ='wWTVOlYJTOa480UFij+NvRO33n8=' and orgRange.FType=20
posted @ 2019-08-06 13:43  一条有梦想的海洋咸鱼  阅读(280)  评论(0)  编辑  收藏  举报