Re: Display Query Result

[Peter Brawley]

Your `howmuch` sum query seems to be missing a table reference and a scope. Shouldn't it be like this?

select sum(howMuch) into MemPayment
from payment
where payer = officeId;

But why not do the whole computation in one query?

select 
  e.spender, 
  sum(e.cost) as totalexpenses,
  r.total,
  p.mempayment,
  r.total + p.mempayment as count,
  r.total + p.mempaymeny - e.totalexpenses as remaining
from expenses e
join (select raiser, sum(totalraised) as total      from raisedfund group by raiser) r on e.spender=r.raiser
join (select payer,  sum(howmuch)     as mempayment from payment    group by payer)  p on e.spender=p.payer
where e.spender=officeID
group by e.spender;