order by foreign key in activerecord

Question

I have a tables Foo and Bar. Foo has one Bar. When I query Foo, how can I order it by a date column in the Bar table?

Thanks

Answer 1

Refer to the ActiveRecord Query Interface page: http://guides.rubyonrails.org/active_record_querying.html#joining-tables

Note that sometimes a prefix is added to the table name so you may need to do something like:

Foo.all(:joins => :bar, :order => Bar.table_name + '.created_at')

Answer 2

Foo.find(:all,:joins=>:boo, :order=>'bars.created_at DESC' )