--查询职位取对应的职务子类sql如下：

 SELECT  "POSITION".FName_l2 AS "职位名称" ,

 "POSITION".FNumber AS "职位编码" ,

 "HRJOBSUBCATEGORY".FName_l2 AS "职务子类名称" ,

 "HRJOBSUBCATEGORY".FNumber AS "职务子类编码" ,

 "HRJOB".FNumber AS "职务编码" ,

 "HRJOB".FName_l2 AS "职务名称" ,

 "HRJOBCATEGORY".FName_l2 AS "职务类名称" ,

 "HRJOBCATEGORY".FNumber AS "职务类编码"

 FROM    T_ORG_POSITION AS "POSITION"

 LEFT JOIN  T_HR_POSITIONEXTEND AS "POSITIONEXTEND" ON "POSITIONEXTEND".FPositionID="POSITION".FID

 LEFT JOIN  T_HR_HRJOB AS "HRJOB" ON "HRJOB".FID="POSITIONEXTEND".FHRJOBID

 LEFT JOIN  T_HR_HRJOBSUBCATEGORY AS "HRJOBSUBCATEGORY" ON "HRJOBSUBCATEGORY".FID="HRJOB".FHRJOBSUBCATEGORYID

 LEFT JOIN  T_HR_HRJOBCATEGORY AS "HRJOBCATEGORY" ON "HRJOBCATEGORY".FID="HRJOB".FHRJOBCATEGORYID