Untitled
unknown
mysql
2 years ago
407 B
17
Indexable
SELECT serialnumber, product, size, bin, location, previousbin, previouslocation FROM inventoryitem WHERE product like '%-_Z%' AND location like '7-%' AND location not like '7-L%' AND location not like '7-U:%' AND previouslocation like '7-T%' AND previouslocation not like '7-T100Q%' AND product not like 'TKEE%' AND qtyonhand = 1 limit 10
Editor is loading...
Leave a Comment