一条UPDATE语句

       
UPDATE TB_CLM_MERGER T1
       SET T_UPD_TM = SYSDATE,(C_CLM_ZC_FEE,t1.c_clm_zc_rate) = (
             SELECT SUM(t2.n_clm_principal +t2.n_clm_interest)*
                           MAX(T4.C_CLM_RATE),max(t4.c_clm_rate)
               FROM tb_clm_list t2,TB_PLY_MAIN T3,TB_CLM_RATE T4
               WHERE  T1.C_MGR_NO=T2.C_MGR_ID  
               AND T2.C_PLY_NO=T3.C_PLY_NO
               AND SUBSTR(T3.C_DPT_CDE,0,2)=T4.C_DPT_CDE
               AND T1.C_CLM_FLAG='9'
               AND t2.c_clm_flag = '1')
WHERE t1.c_Mgr_No ='MERG1260515085919560';