sql 获取上级上上级

原创

晴天MZ 2023-02-28 14:42:34 博主文章分类：金蝶云之家 ©著作权

©著作权归作者所有：来自51CTO博客作者晴天MZ的原创作品，请联系作者获取转载授权，否则将追究法律责任

select * from T_ORG_BaseUnit where fid ='mEcAAAIT3XfM567U'

      select   *  from   T_PM_EASXTUSERMAP  where  FPERSONID='v3w3GHVFRZGyEKIlB1Uq+oDvfe0=' 
 

      select   *   from      T_PM_EASXTORGMAP   where   FEASORGID= 'mEcAAAIT3XfM567U' 

 
 
 
 
-------上级
 select     *  from   T_PM_EASXTUSERMAP  where  FPERSONID  in (select Fpersonid from T_ORG_PositionMember where Fpositionid in (select Fparentid from T_ORG_PositionHierarchy where Fchildid in  (SELECT a.fid FROM T_ORG_Position a LEFT JOIN T_ORG_PositionMember b on a.fid = b.FPOSITIONID where b.FPERSONID = 'v3w3GHVFRZGyEKIlB1Uq+oDvfe0='
  and a.FADMINORGUNITID = 'mEcAAAIT3XfM567U')))   
                  

---间接上级
select     *  from   T_PM_EASXTUSERMAP  where  FPERSONID  in     (   select Fpersonid from T_ORG_PositionMember where Fpositionid in 
     (select Fparentid from T_ORG_PositionHierarchy where Fchildid in 
    (select Fparentid from T_ORG_PositionHierarchy where Fchildid in 
     (SELECT a.fid FROM T_ORG_Position a LEFT JOIN T_ORG_PositionMember b on a.fid = b.FPOSITIONID 
     where b.FPERSONID = 'v3w3GHVFRZGyEKIlB1Uq+oDvfe0='
     
     and a.FADMINORGUNITID = 'mEcAAAIT3XfM567U')))    )