上述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';

SELECT	ManufacturingOrder	Material	Reservation	ReservationItem	sumRequiredQuantity AS requiredQuantity	ManufacturingOrderOperation	BillOfMaterialItemNumber	GoodsMovementType	MaterialGroup FROM	ods_pro

原文地址: https://www.cveoy.top/t/topic/iJxu 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录