Untitled

 avatar
unknown
mysql
2 years ago
228 B
5
Indexable
SELECT 
    CONCAT('s', serialnumber) serial,
    product,
    size,
    bin,
    location,
    lastscandate
FROM
    inventoryitem
WHERE
    product IN ('BOTT-WY1274' , 'BOTT-WY1339') and qtyonhand = 1
    order by location asc
Editor is loading...