Here is exact update :
Update t_client a
set cl001D = cl001D + (select sum(amount)
from t_fh_fs b
where a.clnbr = b.clnbr
and b.department = 2
)
;
Table T_FH_FS has 1 to n transactions for each row of t_client.
|
Results 1 to 9 of 9
Thread: UpdateThreaded View
|
Click Here to Expand Forum to Full Width |