I have two tables, the first has original amount of a fund, the second is related and has increments to that fund amount. I want to sum the original amount and all the increments. How can I do this?
These two queries return the original amount of a fund, and the sum of the increments.
select amount from tds_fund where id = 4
select sum(amount) from tds_fund_amount_added where fk_fund = 4