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
原文地址:https://www.cnblogs.com/luojiabao/p/11308390.html