SELECT  (COUNT(CASE WHEN SaleQuantity < 0 THEN NULL ELSE SaleDetailID END) - COUNT(*) +
COUNT(CASE WHEN SaleQuantity < 0 THEN NULL ELSE SaleDetailID END)) AS SaleLines,
ProductLastBuy,ProductPDE,SupplierName
FROM SaleDetail  INNER JOIN Sale ON (SaleDetail.BusinessCode,SaleDetail.SaleCode) = (Sale.BusinessCode,Sale.SaleCode)
INNER JOIN Product prod ON ProductCode = prod.ProductCode
LEFT OUTER JOIN ProductSupplier ON (ProductCode,PreferredSupplierCode) = (ProductSupplier.ProductCode,ProductSupplier.SupplierCode)
INNER JOIN Supplier ON SupplierCode = Supplier.SupplierCode
WHERE (ProductName BETWEEN '! DISPENSE UPDATED 01-05-11' AND '~Opening Balance' AND Sale.BusinessCode = :businesscode AND
Sale.SaleDate BETWEEN DATE '2011-05-01' AND DATE '2011-05-31' AND Sale.SaleStatus <> '1')
GROUP BY Product.ProductName ORDER BY Product.ProductName JOINOPTIMIZECOSTS