"update Table1 set cl001d=cl001d+(select AMOUNT from table2)" ??? can u explain clearly?
Cheers! OraKid.
Forum Rules