Do you have a space between group.idINNER JOIN users? In your code and log file, it looks like the space is missing.
On May 1, 9:55 am, Stephen Fagan <[email protected]> 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 viahttp://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 -~----------~----~----~----~------~----~------~--~---
