INNER JOINING 3 tables not working 1

[EchoAlertcom]

Hello,

I am using ASP and an Access 2000 Database. I need to Join 3 tables. I understand how to do it but it isn't working. I have pasted the code below, any suggestions would be appreciated:

SELECT U.NName, C.CommitteeName
FROM Users U
INNER JOIN Committee_Members CM ON U.UID = CM.UID 
INNER JOIN Committees C ON CM.CID = C.CID
WHERE U.UID = varintUID

Thank you very much
Steve

 

[laado]

Hi Steve

Try this,

SELECT U.NName, C.CommitteeName
FROM Users U JOIN
(Committee_Members CM JOIN Committees C
ON CM.CID = C.CID)
ON U.UID = CM.UID
WHERE U.UID = varintUID

Hope this helps....

Daljinder

 

[EchoAlertcom]

Thank you, that worked great.

Sincerely,
Steve