Untitled
unknown
mysql
2 years ago
494 B
5
Indexable
SELECT CONCAT('s', serialnumber) serial, product, size, bin, location, lastscandate FROM inventoryitem WHERE (location LIKE '7-A%' OR location LIKE '7-B%' OR location LIKE '7-C%' OR location LIKE '7-U%' OR location LIKE '7-V%' OR location LIKE '7-D%' OR location LIKE '7-E%' OR location LIKE '7-Z%') AND defective = 1 AND sellasdefective = 0 AND Qtyonhand = 1 ORDER BY location ASC
Editor is loading...