Need help in ActiveRecord queries...

[eluser]kgill[/eluser]
Your example query isn't very helpful, you talk about position 1, position 2, but only select id. What columns are you looking to see in the result set, just id? Secondly how are the two tables related, is there a foreign key relationship between them or are they just two separate tables with similar info. That detail makes a huge difference in how the query is written.