Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.02 » View Incident Report |
Serious |
Reported By: Graeme Cox Reported On: 10/30/2008 For: Version 2.02 Build 1 |
SELECT p.ProductCode, p.ProductCode, p.Barcode, p.RetailPrice, p.LastBuyPrice, p.StockOnHand, SUM(sd.SaleQuantity) AS units, SUM(sd.SaleAmount) AS cogs, SUM(sd.SaleQuantity) * SUM(sd.SaleAmount) AS test, SUM(sd.SaleQuantity) / SUM(sd.SaleAmount) AS test1, (p.StockOnHand) * SUM(sd.SaleQuantity) AS test2, SUM(sd.SaleAmount) / StockOnHand AS test3 FROM Product p INNER JOIN SaleDetail sd ON p.ProductCode = sd.ProductCode GROUP BY p.ProductCode ORDER BY p.ProductName
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |