use t202122

update received_detail set recamt=t1.f2 from (select recsrno as f1, sum(paidamt) as f2 from received_addless_detail group by recsrno) as t1 where t1.f1 collate database_default = recsrno




use t202122

update RECEIVED_PAYMENT_DETAIL set recamt=t1.f2 from (select recsrno as f1, sum(paidamt) as f2 from received_addless_detail group by recsrno) as t1 where t1.f1 collate database_default = recsrno