金蝶云星空
即时库存查询语句
shmily 发表于2024-12-29 浏览64 评论0
SELECT TBM.FNUMBER,SUM(TSI.FBASEQTY) 数量
FROM
T_STK_INVENTORY TSI
LEFT JOIN T_BD_MATERIAL TBM ON TSI.FMATERIALID = TBM.FMATERIALID
WHERE TSI.FBASEQTY <> '0'
GROUP BY TBM.FNUMBER