Retrieve value of one column in a table
- by user327094
Here is my problem:
I have 2 tables Accounts and Transaction Logs.
in Accounts table, it has column "Amount" which is a base amount of an account.
and in Trans Logs table, it also has column "Amount" which is additional (add or minus to the base amount) amount of the account.
and I don't know how to retrieve that base amount to edit it, then save…