帮转一段Sql 多谢
我的Sql是这样的,4个表product,order,orderdetail,site
select orderdetail.productid, product.productname,order.ordernumber, sum(orderdetail.quantity),site.sitename
from orderdetail inner join order on orderdetail.ordernumber=order.ordernumber
inner join product on orderdetail.productid=product.productid
inner join site on order.siteid=site.siteid
group by orderdetail.productid, product.productname,order.ordernumber
多谢多谢