Nested Inner Joins

Hi folks,

I have three tables:

ActivityCalls, UserList, and People

UserList.Username and ActivityCalls.Username are 'INNER JOINED' to determine which user is attached to an activity.

What I want to do is go one step further and look up the People.PersonName from people.

Here's what I have so far but it doesn't seem to work... Am I on the wrong track here?

INNER JOIN (People INNER JOIN UserList ON UserList.User_Username=ActivityCalls.Username)
ON People.Person_ID=UserList.Person_ID

Any help would be greatly appreciated.

Thanks

Nick

Quote:

Originally Posted by nkew

Hi folks,

I have three tables:

ActivityCalls, UserList, and People

UserList.Username and ActivityCalls.Username are 'INNER JOINED' to determine which user is attached to an activity.

What I want to do is go one step further and look up the People.PersonName from people.

Here's what I have so far but it doesn't seem to work... Am I on the wrong track here?

INNER JOIN (People INNER JOIN UserList ON UserList.User_Username=ActivityCalls.Username)
ON People.Person_ID=UserList.Person_ID

Any help would be greatly appreciated.

Thanks

Nick

Hi Nick
This might work:

FROM UserList U
INNER JOIN ActivityCalls A
ON U.User_Username = A.Username
INNER JOIN People P
ON U.User_PersonID = P.Person_ID