#库存统计总数量sql映射

zjj

2023-09-05 9f425b85e097352a6f0e796f40705a0819ae2264

#库存统计总数量sql映射

 src/main/resources/mapper/LocDetlMapper.xml

@@ -200,7 +200,7 @@
        select * from
        (
        select ROW_NUMBER() over (order by a.mat_no) as row,
        a.mat_name,a.mat_no,a.str3,sum(a.qty) qty,sum(all_qty) allQty, specs,unit,color,qty_box,weight,str4,str5  from
        a.mat_name,a.mat_no,a.str3,sum(a.qty) qty,sum(all_qty) all_qty, specs,unit,color,qty_box,weight,str4,str5  from
        (
        select
        mat_name,mat_no,str3,qty,all_qty,specs,unit,color,qty_box,weight,str4,str5