# How to Sort by a column from another table

**URL:** <https://www.ruby-forum.com/t/how-to-sort-by-a-column-from-another-table/164513>\
**Category:** Rails\
**Created:** [April 2, 2009, 3:10am UTC](https://www.ruby-forum.com/t/how-to-sort-by-a-column-from-another-table/164513 "2009-04-02T03:10:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sunfish](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/96bed5/32.png) [@sunfish](https://www.ruby-forum.com/u/sunfish)\
**Post date:** [April 2, 2009, 3:10am UTC](https://www.ruby-forum.com/t/how-to-sort-by-a-column-from-another-table/164513/1 "2009-04-02T03:10:33Z")

</div>

I need to create a list of users sorted by division. How do I sort User  
table by Division name? I can only get it to sorted by division\_id.

Part of my code is shown below:

sort = case params[‘sort’]  
when “id” then “id ASC”  
when “email” then “email ASC”  
when “division\_id” then “division\_id ASC”

@users = User.find(:all, :order =\> sort)

---

<div class="post-metadata">

**Author:** ![sunfish](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/96bed5/32.png) [@sunfish](https://www.ruby-forum.com/u/sunfish)\
**Post date:** [April 2, 2009, 4:36am UTC](https://www.ruby-forum.com/t/how-to-sort-by-a-column-from-another-table/164513/2 "2009-04-02T04:36:51Z")

</div>

> @users = User.find(:all, :order =\> sort)

@users = User.find(:all, :include =\> :division, :order =\>  
‘divisions.name’)

(assuming Division has a ‘name’ field)