U8统计月度工作中心工时

SELECT
InvCode, --物料编码
f.cInvName, --物料名称
MDeptCode, --部门代码
d.cDepName, --部门名称
g.Description gxsm, --工序说明
e.WcCode, --工作中心
e.Description as gzzxmc , --工作中心名称
sum(a.QualifiedInQty * c.WorkHour) zgs --总工时
FROM
( SELECT InvCode, QualifiedInQty, MDeptCode,RoutingId FROM mom_orderdetail WHERE QualifiedInQty != 0 AND Status <> ‘4’ ) a
JOIN sfc_moroutingdetail b ON a.RoutingId = b.MoRoutingId
JOIN sfc_moroutingres c ON b.MoRoutingDId = c.MoRoutingDId
JOIN Department d ON d.cDepCode = a.MDeptCode
JOIN sfc_workcenter e on b.WcId = e.WcId
JOIN Inventory f on f.cInvCode = a.InvCode
JOIN sfc_operation g on g.WcId = b.WcId
GROUP BY
InvCode,
f.cInvName,
a.MDeptCode,
d.cDepName,
g.Description,
e.WcCode,
e.Description
ORDER BY e.WcCode,a.MDeptCode