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

[Becker, Holger]

Hi,   the only workaround is to use the syntax with the join condition in the where clause, for example         select * from tab1, tab2, tab3 where tab1.a = tab2.b and tab2.b = tab3.c and tab1.x = 5   HTH.   Kind regards, Holger SAP Labs Berlin    -----Original Message----- From: Ian [mailto:[EMAIL PROTECTED]] Sent: Donnerstag, 10. Oktober 2002 13:24 To: Becker, Holger; [EMAIL PROTECTED] Subject: RE: Inner Join giving Invalid end of SQL error.. Is there a work around for it? Or its just not possible to join 3 tables???   Thanks in advance for your help   -----Original Message----- From: Becker, Holger [mailto:[EMAIL PROTECTED]] Sent: jueves, 10 de octubre de 2002 12:13 To: 'Ian'; [EMAIL PROTECTED] Subject: RE: Inner Join giving Invalid end of SQL error..   Hi,   it's a known bug and will be fixed within the next release. No time schedule by now.   Kind regards, Holger SAP Labs Berlin -----Original Message----- From: Ian [mailto:[EMAIL PROTECTED]] Sent: Donnerstag, 10. Oktober 2002 10:55 To: [EMAIL PROTECTED] Subject: RE: Inner Join giving Invalid end of SQL error.. 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!?