gistfile1.txt

class Budget < ActiveRecord::Base
  belongs_to :event
  belongs_to :category

  scope :for_event, lambda {|event_id| where("event_id = ?", event_id ) },
    :select => '*, ( SELECT SUM(amount) FROM expenses WHERE event_id = budgets.event_id GROUP BY category_id ) AS total'


# the above code error out, wrong params, 3 for 2