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
上一篇:HSV模型


下一篇:OpenCV入门基本知识【不定期更新】