Untitled

mail@pastecode.io avatar
unknown
mysql
15 days ago
243 B
3
Indexable
Never
SELECT 
    serialnumber, product, size, bin, location
FROM
    inventoryitem
WHERE
    product LIKE 'NKAM%' AND qtyonhand = 1
        AND orderhistory = ''
        AND location LIKE '7-%'
        group by product
        order by location asc
Leave a Comment