update Table1 set cl001d=
(select table1.cl001d+AMOUNT from table2 where ......);