![]() | Products |
| Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.05 » 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 DESCThis web page was last updated on Wednesday, October 22, 2025 at 04:21 PM | Privacy Policy © 2026 Elevate Software, Inc. All Rights Reserved Questions or comments ? |

