SELECT ManufacturingOrder Material Reservation ReservationItem sumRequiredQuantity AS requiredQuantity ManufacturingOrderOperation BillOfMaterialItemNumber GoodsMovementType MaterialGroup FROM ods_pro
上述SQL语句有一个错误,即在最后一行的AND语句后面有一个中文分号(;),应删除该分号。
正确的SQL语句如下:
SELECT ManufacturingOrder, Material, Reservation, ReservationItem, sum(RequiredQuantity) AS requiredQuantity, ManufacturingOrderOperation, BillOfMaterialItemNumber, GoodsMovementType, MaterialGroup FROM ods_productionordercomponent WHERE ManufacturingOrder ='1000098000' AND Material = '068840280104007';
原文地址: https://www.cveoy.top/t/topic/iJxu 著作权归作者所有。请勿转载和采集!