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 form of sql assumes that you are giving it a list of associaton names, ie
Membership.find(:all, :joins => [:groups, :users]) looks like it would do what you are trying to do.
The other form involves sql fragments, in which case you must provide one such fragment, not an array ie
@group_members = Membership.find( :all, :joins => 'INNER JOIN groups ON memberships.group_id= group.id INNER JOIN users ON memberships.user_id=users.id')
Fred