iopak.com


SELECT distinct stock.item,stock.CategoryID,category.catTypeId,Category.CategoryName FROM (Category INNER JOIN Stock ON Category.CategoryID = Stock.CategoryID) INNER JOIN Make ON Stock.MakeID = Make.MakeID WHERE (stock.sold=false) and (Stock.status=0) AND ((LCASE(TRIM(Make.MakeDescription))='iopak' or LCASE(TRIM(Make.MakeDescription))='geodicer'))AND stock.StockNumber like '%G' AND Stock.item LIKE '%%'
verticle-fill-form-seal
EXPANDABLE CONVEYORS