|
source=SELECT Item.ItemNo, Item.ItemDescLin1, Item.ItemDescLin2, Item.ItemPrc1, Item.ItemProdCat, Item.ItemStkUnitOfMeas, Item.ItemStat, Item.ItemQtyOnHnd-Item.ItemQtyCommit as Avail, tSalesPrices.SPPrice, tSalesPrices.SPProdFlg, tItemInfo.ThumbNailPath, tItemInfo.ImagePath, tItemInfo.RecipeFile, tItemInfo.TechInfoFile, tItemInfo.ItemDescLin3 FROM (Item INNER JOIN tSalesPrices ON Item.ItemNo = tSalesPrices.ItemNo) LEFT JOIN tItemInfo ON Item.ItemNo = tItemInfo.ItemNo WHERE (tSalesPrices.CustNo='CASH05' OR tSalesPrices.CustNo='CASH06') AND Item.ItemProdCat Like '370%' AND ucase(Trim(SPProdFlg)) <> "F"
|