I have two tables, people and players. When I do a find on Player and
join people, the wrong id is being returned for my player object.
Here is an example.
class Person < ActiveRecord::Base
class Player < ActiveRecord::Base
@players = Player.find(:all,
:joins => "join people on players.person_id = people.id",
:order => "people.last_name, people.first_name"
<% for player in @players %>
<p><%= player.id =>, <%= player.person_id =>
Here is one of the entries in the players table.