求大神帮忙写个SQL语句啊 急用 谢谢

[什么_帝]

表名叫T_MH_TARGET_SUM 根据year，month，把month为11的sum_ndmb的值赋给相同sum_object_id，month为12的

[CT_LXL]

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;

[什么_帝]

引用 1 楼 zlloct 的回复:

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;

执行说无效的SQL语句 报错在meger那

[_拙计]

merge into

[什么_帝]

谢谢大神 受教了 写出来了