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