Untitled

mail@pastecode.io avatar
unknown
mysql
a month ago
225 B
4
Indexable
Never
SELECT 
    CONCAT('s', serialnumber) serial,
    product,
    size,
    bin,
    location,
    lastscandate
FROM
    inventoryitem
WHERE
    product LIKE 'EFCR%'
        AND location LIKE '7-30__-%'
        AND qtyonhand = 1
Leave a Comment