Untitled

mail@pastecode.io avatar
unknown
plain_text
2 months ago
249 B
8
Indexable
Never
SELECT 
    CONCAT('s', serialnumber) serial,
    product,
    size,
    bin,
    location,
    lastscandate
FROM
    inventoryitem
WHERE
    bin LIKE 'b28520%' AND qtyonhand = 1
        AND location LIKE '7-%'
        group by location asc
        
Leave a Comment