Untitled

 avatar
unknown
mysql
9 months ago
272 B
8
Indexable
SELECT 
    count(serialnumber) serial,
    bin,
    location,
    previousbin,
    previouslocation
FROM
    inventoryitem
WHERE
    location = 'qc pending' and bin = 'bDamagedInventory'
        AND qtyonhand = 1
        group by previousbin
ORDER BY previouslocation ASC
Editor is loading...
Leave a Comment