![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.04 » View Incident Report |
![]() |
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 Tuesday, April 23, 2024 at 08:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |