SELECT
au_employee. ID,
POSTALCODE,
AU_EMPLOYEE.REMARK,
ENABLE_STATUS,
ENABLE_DATE,
AU_EMPLOYEE.CREATE_DATE,
MODIFY_DATE
FROM
AU_EMPLOYEE
LEFT JOIN BAS_SCHOOL school ON school.SCHOOL_ID = AU_EMPLOYEE.COLUMN1
LEFT JOIN AU_POSITION position ON position. ID = AU_EMPLOYEE.POSITION_ID
WHERE
au_employee. ID =1
MODIFY_DATE 在表AU_EMPLOYEE和表AU_POSITION都存在 ,在两个不同的库里,一个可以正常运行,一个报 [Err] ORA-00918: 未明确定义列