Active record - sorting (ordering) of results

Rails
1

I have a model User. User has_one Profile. Profile has a field
first_name.

I want to get users from User table, ordered by his first_name (which
is a field in Profile table). Is it possible? how do i do it?

Thanks
Unni

2

@users = User.find(:all, :include => [:profile], :order =>
“profiles.first_name”)

should work

3

thanks. it worked.