SELECT a.ACC_TYPE,a.PART_NO,a.TOTAL_QTY,a.PART_MEMO1,a.PART_MEMO2,a.PART_MEMO3
,b.PART_NO,b.PART_NAME,b.PART_SPEC,a.TOTAL_QTY*b.BOM_QPA/b.USE_BASE PART_QTY
FROM NEMS.EMS_ACCPART a,NEMS.EMS_ACCBOM b
WHERE a.ACPT_ID=b.ACPT_ID AND a.ACC_ID=2002 AND b.PART_TYPE='1'
關務賬務SQL
最新推荐文章于 2022-07-18 15:06:49 发布