|
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
|
