With ActiveRecord, how do I sort results using associations? For example, I have
class Roster < ActiveRecord # name => text has_many :members end class Member < ActiveRecord # zip_code => integer belongs_to :roster end I would like to generate a list of members, grouped by roster name, sub-sorted by zip code. Something like this: Member.order("roster.name, zip_code").all But I can't get the syntax quite right - I've played around with join and include - can anyone tell me the right syntax to use?? thanks, Andy -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-t...@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.