General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only