UPDATE APP_03 SET a.C10 = a.C10 + b.C08 ,a.C12 =a.C12+ b.C08, a.C16 = a.C16 + b.C08 FROM APP_03 a,APP_02 b WHERE a.C03=b.C06 AND b.C02='2201012009110012';
我是新手,这么写出错,请大家帮忙看一下
------解决方案--------------------------------------------------------
- SQL code
update APP_03 a inner join APP_02 b on a.C03=b.C06 SET a.C10 = a.C10 + b.C08 , a.C12 =a.C12+ b.C08, a.C16 = a.C16 + b.C08