Hi, I make a join with two tables. After this join ActiveRecord uses the id from the wrong table. @port_time_pages, @port_times = paginate :port_time, :per_page => 10, :join => "as pt inner join ship_days as sd on pt.ship_day_id=sd.id", :order_by => "sd.no, pt.arrive1" After this the ID from the Ship_Days Table is used, but I need Port_Time ID. What`s wrong with my code ? odo