求助：查询错误 - 编程论坛

#2

madpbpl2008-02-04 21:11

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好象不能这样写的。

#3

cyyu_ryh2008-02-14 15:46

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

#4

cyyu_ryh2008-02-14 16:07

可以了，在前加个括号就可以了
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]