select 批号,车间,工序名称,投入数,产出数 from (
select BatchID 批号,DeptName 车间,WorkProcedureName 工序名称,InNumber 投入数,OutNumber 产出数,WorkProcedureName flag1,0 flag2 from Table_WorkRecord where BatchID='2307081184'
union all
select '合计','','',sum(InNumber),sum(OutNumber),WorkProcedureName,1 from Table_WorkRecord where BatchID='2307081184' group by WorkProcedureName
) tem order by flag1,flag2
select BatchID 批号,DeptName 车间,WorkProcedureName 工序名称,InNumber 投入数,OutNumber 产出数,WorkProcedureName flag1,0 flag2 from Table_WorkRecord where BatchID='2307081184'
union all
select '合计','','',sum(InNumber),sum(OutNumber),WorkProcedureName,1 from Table_WorkRecord where BatchID='2307081184' group by WorkProcedureName
) tem order by flag1,flag2
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货