Relationships using mutiple joins

[lcurrie]

Hi all.

I'm having a problem pulling all the data out of some databases. I'd like to create one page that has all pertinent info.

This is what I have (I'm only putting the fields that need relating in for simplicity)

_____________

GROUP

group_id

user_id

_____________

GROUP_ATTENDEES

group_id

attendee_id

_____________

ATTENDEES

attendee_id

user_id

_____________

USERS

user_id

_____________

What I'd like to do: pull data from USERS and place on GROUP that is related by attendee_id.

HELP!! (please)

Thanks!

Lynn