Hi all,

I'm having trouble getting the sum statement to work for the following query, I can get it to work in SQL like so:

SELECT sum( amount )
FROM expenses, budget_accounts
WHERE budget_account_id = budget_accounts.id
AND signup_id =1;

#Where signup_id would normally be the currently logged in user, not hard-coded 1.

But I can't figure out how to get this to work using RoR code.

What it's trying to do is sum up all the expense amounts for a particular user (budget_accounts.signup_id value). What makes it difficult is that the person can have more than one budget.

Thanks for your help!