SERVICE_STOP_DATE DATE, SUB_ID INT, SERVICE_NAME VARCHAR(100)); insert into SERVICE values(2021-5-7, 2021-6-7, 98, 'Internet');
insert into SERVICE values(202
,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</