Can we update another table while dealing with a table

[Altaful Haq]

I had two tables BALANCE and CUSTOMER
CUSTOMER: ID, Name, OldBalance
BALANCE: BID, ID, NewBalance, PaidAmount, RemainBalance
I need to update the OldBalance column of Customer table by putting the value of RemainBalance in it.


Need Help

[Xipooo]

Although this CAN be done, I would suggest you rethink how you are tracking your transactions. It is far better to maintain a table of each adjustment and then do queries against that table to determine balances.