Untitled

mail@pastecode.io avatar
unknown
mysql
2 months ago
357 B
4
Indexable
Never
SELECT 
    serialnumber, product, size, bin, location, previousbin, previouslocation
FROM
    inventoryitem
WHERE
   product like '%-_A%'
        AND location like '7-%'
        AND location not like '7-L%' AND location not like '7-U:%'
        AND previouslocation like '7-T%'
        AND product not like 'RBEA%'
        AND qtyonhand = 1
        limit 5
Leave a Comment