Getting data from two table fields with calculation
Posted: 2014-05-19 15:03
hi, can someone pls help me out.
i am trying to display the result of the subtraction of two tables, then update a field .
What i expect it to do is this MY_WALLET = MY_WALLET_COST - TREATMENT_COST, then it should further update MY_WALLET_COST
Thanks,
Dallo
i am trying to display the result of the subtraction of two tables, then update a field .
What i expect it to do is this MY_WALLET = MY_WALLET_COST - TREATMENT_COST, then it should further update MY_WALLET_COST
Thanks,
Dallo