金蝶云星空-即时库存查询语句

三四五六

/*SQL语句*/
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