"update Table1 set cl001d=cl001d+(select AMOUNT from table2)"
???

can u explain clearly?