日期:2014-05-17 浏览次数:20757 次
meger into T_MH_TARGET_SUM t2 using(select * from T_MH_TARGET_SUM where t.month=11) t1 on (t1.sum_object_id=t2.sum_object_id and t2.month=12) when matched then update t2 set t2.sum_ndmb=t1.sum_ndmb;