I don't know the answer but something that jumped out at me was that you don't have a space in between "group.idINNER". You may want to try it with something like
:joins => ['FROM memberships INNER JOIN groups ON memberships.group_id= group.id' + ' INNER JOIN users ON memberships.user_id=users.id']) Note the single space before second INNER -S Stephen Fagan wrote: > I want to link up 3 tables to list all members of a particular group. My > code (which is wrong) looks like this: > > @group_members = Membership.find( :all, > :joins => ['FROM memberships INNER > JOIN groups ON memberships.group_id= group.id' + 'INNER JOIN users ON > memberships.user_id=users.id']) > > > This gives me an "association name not found" error. From my log file > the sql string is as follows: > > 'FROM memberships INNER JOIN groups ON memberships.group_id= > group.idINNER JOIN users ON memberships.user_id=users.id' > > Can anyone please let me know where I'm going wrong - SQL is not my > forté :@/ > > > Thanks > > > Steve -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
