Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.05 » View Incident Report |
Serious |
Reported By: Chris B Reported On: 12/12/2010 For: Version 2.04 Build 4 |
SELECT ordering_field, Product.ProductCode AS ProductCode FROM Product INNER JOIN (SELECT SUM(SaleQuantity) AS ordering_field, Product.ProductCode AS ProductCode FROM Product INNER JOIN ProductSaleHistory ON Product.ProductCode = ProductSaleHistory.ProductCode GROUP BY ProductCode ORDER BY ordering_field DESC RANGE 1 TO 10) AS TopProductSaleHistory ON Product.ProductCode = TopProductSaleHistory.ProductCode INNER JOIN ProductSaleHistory ON Product.ProductCode = ProductSaleHistory.ProductCode INNER JOIN Business ON ProductSaleHistory.BusinessCode = Business.BusinessCode Product.ProductCode = ProductSaleHistory.ProductCode GROUP BY ProductCode ORDER BY ordering_field DESC
This web page was last updated on Wednesday, October 30, 2024 at 11:41 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |