Untitled

mail@pastecode.io avatar
unknown
mysql
a year ago
226 B
3
Indexable
Never
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