merge into lzyrealamount_gsm_0912 a
using (select svcnum, sum(chrgamount) as chrgamount
from lzysvcnum_acctinsht
group by svcnum ) b
on(a.msisdn=b.svcnum )
when matched then update set (a.chargefee=b.chrgamount)
用觸發器吧。
create or replace trigger tri_update
after update of createUser on table1
begin
update table2 set createUser = :new.createUser where userId = :old.userId;
update table3 set createUser = :new.createUser where userId = :old.userId; update table4 set createUser = :new.createUser where userId = :old.userId;