,m_office_types WHERE SUPERVISOR_OFFICE_CD =officecd
AND m_office_hierarchy.office_cd=m_office_types.office_cdAND m_office_hierarchy.office_cd=m_office_types.office_cd AND m_office_hierarchy.lang_cd=m_
我想更新OFFICE_ID,OFFICE_TYPE of FA_SUBLEDGER_MST表,方法是根据以下条件从EMPLOYEE_MST表中使用OFFICE_ID,OFFICE_TYPE:EMPLOYEE_MST.OFFICE_ID <> SL.OFFICE_ID
OR EMPLOYEE_MST.OFFICE_TYPE <> SL.OFF
我想更新OFFICE_ID,OFFICE_TYPE of FA_SUBLEDGER_MST表,方法是根据以下条件从EMPLOYEE_MST表中使用OFFICE_ID,OFFICE_TYPE:
EMPLOYEE_MST.SL_CODE=FA_SUBLEDGER_MST.SL_CODE EMPLOYEE_MST.OFFICE_ID<>SL.OFFICE_ID OR EMPLOYEE_MST.OFFICE_TYPE<>SL.OFFICE</