Working With Rails

I’ve implemented will_paginate with no problems. But I want to sort on by company_name, the user table is related to the companies table by company_id

user
belongs_to :company

company
has_many :users

sort_init ‘company_id’
sort_update
@users = User.paginate(:page => params[:page], :per_page => 10, :order => sort_clause, :include => :company)

Any ideas, unfortunately I get an error because the sql generated says order_by company_name and the sql generated is

Invalid column name ‘company_name’. HRESULT error code:0×80020009 Exception occurred.: SELECT * FROM (SELECT TOP 10 * FROM (SELECT TOP 10 users.[id] AS t0_r0, users.[employee_id] AS t0_r1, users.[user_name] AS t0_r2, users.[certificate] AS t0_r3, users.[date_valid_from] AS t0_r4, users.[date_valid_to] AS t0_r5, users.[status] AS t0_r6, users.[hashed_password] AS t0_r7, users.[email_address] AS t0_r8, users.[business_stream_id] AS t0_r9, users.[company_id] AS t0_r10, users.[time_zone] AS t0_r11, users.[language_id] AS t0_r12, users.[created_at] AS t0_r13, users.[created_by] AS t0_r14, users.[updated_at] AS t0_r15, users.[updated_by] AS t0_r16, users.[role_id] AS t0_r17, users.[salt] AS t0_r18, users.[enabled] AS t0_r19, companies.[id] AS t1_r0, companies.[company_registered_number] AS t1_r1, companies.[address_line_1] AS t1_r2, companies.[address_line_2] AS t1_r3, companies.[city] AS t1_r4, companies.[state] AS t1_r5, companies.[country_id] AS t1_r6, companies.[parent] AS t1_r7, companies.[licence] AS t1_r8, companies.[sales_tax_number] AS t1_r9, companies.[max_range_limits] AS t1_r10, companies.[created_on] AS t1_r11, companies.[created_at] AS t1_r12, companies.[updated_at] AS t1_r13, companies.[updated_on] AS t1_r14, companies.[created_by] AS t1_r15, companies.[updated_by] AS t1_r16, companies.[ultimate_parent] AS t1_r17, companies.[date_valid_from] AS t1_r18, companies.[date_valid_to] AS t1_r19, companies.[status] AS t1_r20, companies.[max_number_replies] AS t1_r21, companies.[company_name] AS t1_r22, companies.[domain_name] AS t1_r23 FROM users LEFT OUTER JOIN companies ON companies.id = users.company_id ORDER BY company_name asc) AS tmp1 ORDER BY company_name DESC) AS tmp2 ORDER BY company_name asc

ActiveRecord::StatementInvalid (DBI::DatabaseError: Execute OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server Invalid column name ‘company_name’.