根据查询出各地订单商品数量 group by

根据查询出各地订单商品数量 group by

 

order订单表，orderprduct订单商品表，area地区表

SELECT (a1.Name+a2.Name+a3.Name) AS areanaem,orderArea.AreaId,orderArea.number
FROM (SELECT a.areaid,COUNT(a.areaid) AS number
FROM (SELECT o.AreaId FROM order AS o LEFT JOIN dbo.OrderProduct AS op ON op.OrderNumber = o.Number WHERE o.areaid>0) AS a
GROUP BY a.areaid ) AS orderArea
LEFT JOIN dbo.Area AS a3 ON orderArea.AreaId=a3.ID
LEFT JOIN dbo.Area AS a2 ON a3.HeadID =a2.ID
LEFT JOIN dbo.Area AS a1 ON a2.HeadID = a1.ID

posted on 2014-05-07 10:05 巛 阅读( ...) 评论( ...) 编辑 收藏

转载于:https://www.cnblogs.com/irelands/p/3713147.html