Untitled

mail@pastecode.io avatar
unknown
mysql
a month ago
218 B
4
Indexable
Never
SELECT 
    COUNT(serialnumber) serials,
    product,
    bin,
    location,
    lastscandate
FROM
    inventoryitem
WHERE
    location = 'PA Replenishment in-transit'
        AND qtyonhand = 1
        group by product
Leave a Comment