Untitled
unknown
mysql
a year ago
225 B
9
Indexable
SELECT CONCAT('s', serialnumber) serial, product, size, bin, location, lastscandate FROM inventoryitem WHERE location LIKE '7-%' AND product = 'alliance code' AND qtyonhand = 1
Editor is loading...
SELECT CONCAT('s', serialnumber) serial, product, size, bin, location, lastscandate FROM inventoryitem WHERE location LIKE '7-%' AND product = 'alliance code' AND qtyonhand = 1