mysql on clause_ON子句中的MySQL未知列無法正常工作

I have this query:

我有這個問題:

select orders.*

,customers.name as customername

,customers.city as customercity

,managers.name as managername

,godowns.name as godownname

from orders

inner join customers

inner join managers

inner join godowns on orders.customerid=customers.customerid

and orders.managerid=managers.managerid

and orders.godownid=godowns.godownid

order by orderid desc;

I'm getting following error:

我收到以下錯誤:

Unknown column 'orders.customerid' in 'on clause'

'on子句'中的未知列'orders.customerid'

I have been bugging at this for over a day. It works in one system, not in another!

我一直在討厭這一天超過一天。它適用於一個系統,而不是另一個系統!

1 个解决方案

#1

1

select orders.*,customers.name as customername,customers.city as customercity,managers.name as managername,godowns.name as godownname

from orders

inner join customers on orders.customerid=customers.customerid

inner join managers on orders.managerid=managers.managerid

inner join godowns on orders.godownid=godowns.godownid

order by orderid desc

Every join needs an on clause

每個連接都需要一個on子句