表关联更新语句:
场景:
表:
AM_APPROVE_LIST_LOG_SAMMY
AM_APPROVE_LIST_SAMMY
更新栏位:
EMP_ID, APPROVER_SEQUENCE, APPROVER_ID
关联栏位:
EMP_ID, APPROVER_ID
方法一:UPDATEam_approve_list_log_sammy aSET(a.emp_id, a.approver_sequence, a.approver_id)=(SELECTb.emp_id, b.approver_sequence, b.approver_idFROMam_approve_list_sammy bWHEREb.emp_id=a.emp_idANDb.approver_id=a.approver_id)WHEREEXISTS(SELECT1FROMam_approve_list_sammy cWHEREc.emp_id=a.emp_idANDc.approver_id=a.approver_id)
方法二:(10g(含)以上版本才可以使用)
MERGEINTOgt$fm_form_field_import imp
USING fm_form_field fieON( imp.field_name=fie.field_nameANDfie.form_kind='BQE.FORM.7'ANDfie.table_name='BQEFORM7')WHENMATCHEDTHENUPDATESETimp.description=fie.description,
imp.is_query=fie.is_query,
imp.is_default_value=fie.is_default_value,
imp.is_query_show=fie.is_query_show,
imp.is_form_show=fie.is_form_show,
imp.is_participant=fie.is_participant,
imp.is_mail_show=fie.is_mail_show