How to sort related tables correctly?

Question

Ruby on Rails

If I want to sort all contracts by department name, am I doing the right thing?
@contracts = Contract.includes(:department).order('departments.name asc')

class Department < ActiveRecord::Base
  has_many :contracts
end

class Contract < ActiveRecord::Base
  belongs_to :department	
end

Answer 1

Contract.joins(:department).order('departments.name asc')

But if my memory serves me right, then rails will process your request using INNER JOIN and sort it correctly.

Answer 2

fix the endings a bit
@contracts = Contract.includes(:department s ).order('departments.name asc')