SQL joins question

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