# Active record - sorting (ordering) of results

**URL:** <https://www.ruby-forum.com/t/active-record-sorting-ordering-of-results/142990>\
**Category:** Rails\
**Created:** [July 14, 2008, 9:18am UTC](https://www.ruby-forum.com/t/active-record-sorting-ordering-of-results/142990 "2008-07-14T09:18:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![unni123](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/94ad74/32.png) [@unni123](https://www.ruby-forum.com/u/unni123)\
**Post date:** [July 14, 2008, 9:18am UTC](https://www.ruby-forum.com/t/active-record-sorting-ordering-of-results/142990/1 "2008-07-14T09:18:46Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![unni123](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/94ad74/32.png) [@unni123](https://www.ruby-forum.com/u/unni123)\
**Post date:** [July 14, 2008, 10:40am UTC](https://www.ruby-forum.com/t/active-record-sorting-ordering-of-results/142990/2 "2008-07-14T10:40:52Z")

</div>

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

should work

---

<div class="post-metadata">

**Author:** ![unni123](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/94ad74/32.png) [@unni123](https://www.ruby-forum.com/u/unni123)\
**Post date:** [July 15, 2008, 7:15am UTC](https://www.ruby-forum.com/t/active-record-sorting-ordering-of-results/142990/3 "2008-07-15T07:15:15Z")

</div>

thanks. it worked.