即时库存查询语句

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