Untitled

 avatar
unknown
mysql
a year ago
243 B
7
Indexable
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
Editor is loading...
Leave a Comment