level 1
FROM T_BD_Person PERSON
INNER JOIN T_ORG_PositionMember POSITIONMEMBER--职员_任职情况
ON PERSON.FID = POSITIONMEMBER.FPersonID
INNER JOIN T_ORG_Position POSITION--职位
ON POSITIONMEMBER.FPositionID = POSITION.FID
LEFT OUTER JOIN T_ORG_Admin ADMINORGUNIT
ON POSITION.FAdminOrgUnitID = ADMINORGUNIT.FID
LEFT OUTER JOIN T_ORG_Admin ADMINORGUNIT2
ON ADMINORGUNIT.FCOMPANYID = ADMINORGUNIT2.FID
2018年09月11日 07点09分