update T_Cj_modify_del_log
set XDXN_NEW = a.XDXN,
XDXQ_NEW = a.XDXQ,
QDXN_NEW = a.QDXN,
QDXQ_NEW = a.QDXQ,
QDCS_NEW = a.QDCS,
XDXZ_NEW = a.XDXZ,
KHFS_NEW = a.KHFS,
ZFX_NEW = a.ZFX,
TSQKBJ_z_NEW = a.TSQKBJ_z,
TSQKBJ_m_NEW = a.TSQKBJ_m,
QDFS_NEW = a.QDFS,
PSCJBFB_NEW = a.PSCJBFB,
PSCJ_NEW = a.PSCJ,
PSCJ_BXXS_NEW = a.PSCJ_BXXS,
QZCJBFB_NEW = a.QZCJBFB,
QZCJ_NEW = a.QZCJ,
QZCJ_BXXS_NEW = a.QZCJ_BXXS,
QMCJBFB_NEW = a.QMCJBFB,
QMCJ_NEW = a.QMCJ,
QMCJ_BXXS_NEW = a.QMCJ_BXXS,
KSCJ_NEW = a.KSCJ,
KSCJ_BXXS_NEW = a.KSCJ_BXXS,
KCLB1_NEW = a.KCLB1,
KCLB2_NEW = a.KCLB2,
KCLB3_NEW = a.KCLB3,
KCLB4_NEW = a.KCLB4,
BYSJMC_NEW = a.BYSJMC,
LRCJFS_NEW = a.LRCJFS,
LRRQ_PS_NEW = a.LRRQ_PS,
LRR_PS_NEW = a.LRR_PS,
LRRQ_QZ_NEW = a.LRRQ_QZ,
LRR_QZ_NEW = a.LRR_QZ,
LRRQ_QM_NEW = a.LRRQ_QM,
LRR_QM_NEW = a.LRR_QM,
LRRQ_ZH_NEW = a.LRRQ_ZH,
LRR_ZH_NEW = a.LRR_ZH,
BZ_NEW = a.BZ,
kc_flag_NEW = a.kc_flag,
xf_NEW = a.xf,
jscj_NEW = a.jscj,
llcj_NEW = a.llcj,
sycj_NEW = a.sycj,
sjcj_NEW = a.sjcj,
tlcj_NEW = a.tlcj,
JNCJLB_NEW = a.JNCJLB,
JNCJ_BXXS_NEW = a.JNCJ_BXXS,
JNCJBFB_NEW = a.JNCJBFB,
JNCJ_NEW = a.JNCJ,
P_FLAG_NEW = a.P_FLAG,
T_Cj_modify_del_log.flag = ''
from T_Cj_modify_del_log left outer join t_cj_lessscoreinfo_detail a on
T_Cj_modify_del_log.code =a.code
where T_Cj_modify_del_log.flag = '1'
set XDXN_NEW = a.XDXN,
XDXQ_NEW = a.XDXQ,
QDXN_NEW = a.QDXN,
QDXQ_NEW = a.QDXQ,
QDCS_NEW = a.QDCS,
XDXZ_NEW = a.XDXZ,
KHFS_NEW = a.KHFS,
ZFX_NEW = a.ZFX,
TSQKBJ_z_NEW = a.TSQKBJ_z,
TSQKBJ_m_NEW = a.TSQKBJ_m,
QDFS_NEW = a.QDFS,
PSCJBFB_NEW = a.PSCJBFB,
PSCJ_NEW = a.PSCJ,
PSCJ_BXXS_NEW = a.PSCJ_BXXS,
QZCJBFB_NEW = a.QZCJBFB,
QZCJ_NEW = a.QZCJ,
QZCJ_BXXS_NEW = a.QZCJ_BXXS,
QMCJBFB_NEW = a.QMCJBFB,
QMCJ_NEW = a.QMCJ,
QMCJ_BXXS_NEW = a.QMCJ_BXXS,
KSCJ_NEW = a.KSCJ,
KSCJ_BXXS_NEW = a.KSCJ_BXXS,
KCLB1_NEW = a.KCLB1,
KCLB2_NEW = a.KCLB2,
KCLB3_NEW = a.KCLB3,
KCLB4_NEW = a.KCLB4,
BYSJMC_NEW = a.BYSJMC,
LRCJFS_NEW = a.LRCJFS,
LRRQ_PS_NEW = a.LRRQ_PS,
LRR_PS_NEW = a.LRR_PS,
LRRQ_QZ_NEW = a.LRRQ_QZ,
LRR_QZ_NEW = a.LRR_QZ,
LRRQ_QM_NEW = a.LRRQ_QM,
LRR_QM_NEW = a.LRR_QM,
LRRQ_ZH_NEW = a.LRRQ_ZH,
LRR_ZH_NEW = a.LRR_ZH,
BZ_NEW = a.BZ,
kc_flag_NEW = a.kc_flag,
xf_NEW = a.xf,
jscj_NEW = a.jscj,
llcj_NEW = a.llcj,
sycj_NEW = a.sycj,
sjcj_NEW = a.sjcj,
tlcj_NEW = a.tlcj,
JNCJLB_NEW = a.JNCJLB,
JNCJ_BXXS_NEW = a.JNCJ_BXXS,
JNCJBFB_NEW = a.JNCJBFB,
JNCJ_NEW = a.JNCJ,
P_FLAG_NEW = a.P_FLAG,
T_Cj_modify_del_log.flag = ''
from T_Cj_modify_del_log left outer join t_cj_lessscoreinfo_detail a on
T_Cj_modify_del_log.code =a.code
where T_Cj_modify_del_log.flag = '1'
where b.code=a.code and b.flag='1')
set tlcjb=tlcja ..对应的更新....