Solved (though I'm not entirely sure why this works): UtilityDatum. select("sum(ami_residential)"). where(:utility => u). group("utility_id"). reorder(''). first
The reorder() prevents the ORDER BY clause from being emitted, so the generated SQL is valid. -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscr...@googlegroups.com. To post to this group, send email to rubyonrails-talk@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/9e71aacaa8c39b5631efe9aa48fc3563%40ruby-forum.com. For more options, visit https://groups.google.com/groups/opt_out.