>Dear Sir,
>
>Actually there are two tables, table1 and table2
>table1 has actual values
>table2 has supposed sumed values
>
>table1 has following data
>
>code--dr_amount
>--1-----24900
>--1-----70200
>--1-----71500
>--2-----14900
>--2-----10200
>--2-----11500
>
>Table2 has following data
>
>code--dr_amount
>--1-----157360
>--2-----35000
>
>I want to display table1 as following to equilize dr_amount in table2
>
>code--dr_amount
>--1-----15660
>--1-----70200
>--1-----71500
>--2-----13300
>--2-----10200
>--2-----11500
>
>there is change in only first record to adjust data according to table2
>
>Please help
And what if the difference is bigger than value of the first record?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.