select Users.UserID as UserID,Users.CustomerName,Users.CustomerAddress,Users.CustomerTelephone,Users.ZipCode,Flower.[ID],Shopping.[ID],Shopping.UserID as SuserID from Users left join  Shopping on Users.UserID=Shopping.UserID left join Flower on Shopping.[ID]=Flower.[ID]
我在ACCECE查询分析器里面始终是这个错误

语法错误 (操作符丢失) 在查询表达式 'Users.UserID=Shopping.UserID                            left join Flower on Shopping.[ID]=Flower.[ID]' 中。

但是在SQL2000中不报错
请问为什么？我需要用ACCECE语句

select Users.UserID as UserID,Users.CustomerName,Users.CustomerAddress,Users.CustomerTelephone,Users.ZipCode,Flower.[ID],Shopping.[ID],Shopping.UserID as SuserID from Users,Flower left join  Shopping on Users.UserID=Shopping.UserID where Shopping.[ID]=Flower.[ID]
改成这样试试,两个left join好象不能这样写的。

也不行啊
提示：
JOIN 操作语法错误。

可以了，在前加个括号就可以了
select Users.UserID as UserID,Users.CustomerName,Users.CustomerAddress,Users.CustomerTelephone,Users.ZipCode,Flower.[ID],Shopping.[ID],Shopping.UserID as SuserID from (Users left join  Shopping on Users.UserID=Shopping.UserID) left join Flower on Shopping.[ID]=Flower.[ID]