有库存量无成本物料查询

示例代码

SELECT  t0.ItemCode ,
        t1.ItemName ,
        t0.WhsCode ,
        t0.OnHand ,
        t0.AvgPrice
FROM    OITW t0
        INNER JOIN OITM t1 ON t0.ItemCode = t1.ItemCode
WHERE   t0.OnHand > 0
        AND t0.AvgPrice = 0