【泛微E9】查询流程审批人中的离职人员

SELECT DISTINCT A.WORKFLOWNAME,C.NODENAME,G.LASTNAME,G.STATUS,G.WORKCODE,G.ID
FROM workflow_base AS A 
INNER JOIN workflow_flownode AS B ON B.WORKFLOWID = A.ID 
INNER JOIN workflow_nodebase AS C ON B.NODEID=C.ID 
INNER JOIN workflow_nodegroup AS D ON C.ID=D.NODEID 
INNER JOIN workflow_groupdetail AS E ON D.ID=E.GROUPID 
INNER JOIN workflow_hrmoperator AS F ON E.GROUPID=F.GROUPID 
INNER JOIN hrmresource AS G ON F.OBJID=G.ID 
WHERE G.STATUS='5' ORDER BY A.WORKFLOWNAME