|
这段sQL中的hek_postions 表名字不对。
SELECT HekEmployeeEO.EMPLOYEE_ID,
HekEmployeeEO.FULL_NAME,
HekEmployeeEO.EMAIL_ADDRESS AS EMPLOYEE_EMAIL, HekEmployeeEO1.EMPLOYEE_ID AS MANAGER_ID,
HekEmployeeEO1.FULL_NAME AS MANAGER_NAME,
HekEmployeeEO1.EMAIL_ADDRESS AS MANAGER_EMAIL, hp.meaning AS POSITION_DISPLAY
FROM HEK_EMPLOYEES HekEmployeeEO,
HEK_EMPLOYEES HekEmployeeEO1,
hek_postions hp
WHERE HekEmployeeEO.MANAGER_ID = HekEmployeeEO1.EMPLOYEE_ID(+) and HekEmployeeEO.POSITION_CODE = hp.lookup_code |
|