查询职位取对应的职务子类sql

--查询职位取对应的职务子类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="POSIT