Untitled

 avatar
unknown
mysql
2 years ago
226 B
6
Indexable
SELECT 
    serialnumber, product, size, bin, location, lastscandate
FROM
    inventoryitem
WHERE
    product IN ('ANIN-WS125' , 'ANIN-WK134', 'LCDE-WD373', 'ANIN-WS109')
        AND qtyonhand = 1
        order by location asc
Editor is loading...