Using find with multiple objects in active record

Hi,

I am trying to learn to use RoR by making a simple social networking
example. Given a user id, I am trying to make a query that finds all of
the group that user belongs to but also rank the groups by one of the
groups’ parameter like group.size. Pretend group.size is a number from
1-10 and is precalculated. Can I do this is one query? Here are the
relationships I set up:

class User < ActiveRecord::Base
has_and_belongs_to_many :groups
end

class Groupship < ActiveRecord::Base
set_table_name “users_groups”
belongs_to :recipes
belongs_to :tags
end

class Group < ActiveRecord::Base
has_and_belongs_to_many :users
end

Thanks!

This should do it.

groups = user.groups.find(:all,:order => ‘size’)


– Tom M.