不灭的焱

常用 数据表

成品库存（已入库 且 未出库）：在库的构件

SELECT
    O.POrderId,
    P.ProductId,
    P.cName,
    T.ForShort
FROM
    ch1_shipsplit SP
INNER JOIN yw1_ordersheet O ON
    O.POrderId = SP.POrderId
LEFT JOIN productdata P ON
    P.ProductId = O.ProductId
LEFT JOIN productstock K ON
    K.ProductId = P.ProductId
LEFT JOIN yw1_ordermain M ON
    M.OrderNumber = O.OrderNumber
LEFT JOIN trade_object T ON
    T.CompanyId = M.CompanyId
WHERE
    O.Estate > 0 
    AND SP.Estate = 1
    AND K.tStockQty >= SP.Qty 
    
    -- AND O.StackId = 'C30' -- 垛号