RE: Inner Join giving Invalid end of SQL error..

[Ian]

Actually the problem seems to lay with the second join, if I take out the INNER JOIN Extension ON Users.UserID = Extension.UserID  .. then everything is ok, if it possible to do more than one join???   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Ian Sent: jueves, 10 de octubre de 2002 10:50 To: [EMAIL PROTECTED] Subject: Inner Join giving Invalid end of SQL error..   Hi there,   Can somebody give me a hand with an INNERJOIN… I have the following SQL SELECT Statement that worked fine in SQL Server but gives an “Invalid end of sql statement”. I know you can do the Join in the WHERE but I also thought you could do the Join in the FROM as per this..   Any ideas? … Thanks in advance..   SELECT DISTINCT AcdID, Hookstate FROM Acd_members INNER JOIN Users ON Acd_members.UserID = Users.UserID  INNER JOIN Extension ON Users.UserID = Extension.UserID This email has been scanned for viruses and found to be clean. I can be contacted via MSN Messenger using [EMAIL PROTECTED] as the signin name. Why not use it!?