Untitled

 avatar
unknown
mysql
a year ago
219 B
12
Indexable
SELECT 
    CONCAT('s', serialnumber) serial,
    product,
    size,
    bin,
    location,
    lastscandate
FROM
    inventoryitem
WHERE
    product LIKE 'nkam%' and qtyonhand = 1
    and orderhistory = ''
    limit 20
Editor is loading...
Leave a Comment