阅读背景:

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;
select orders.*



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: