![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.05 » View Incident Report |
![]() |
Reported By: Jeff Dunlop Reported On: 12/14/2010 For: Version 2.04 Build 4 |
SELECT false as HireExtensionFlag FROM SaleDetail INNER JOIN Sale ON (SaleDetail.BusinessCode,SaleDetail.SaleCode) = (Sale.BusinessCode,Sale.SaleCode) INNER JOIN Product ON SaleDetail.ProductCode = Product.ProductCode RIGHT OUTER JOIN MinfosTime ON MinfosTime.TheTimeIs = Sale.SaleTime WHERE (Sale.SaleDate BETWEEN DATE '2010-11-16' AND DATE '2010-11-16' AND Sale.SaleStatus <> '1' AND SaleTime BETWEEN TIME '08:00' AND TIME '21:00' AND ProductType IN (1,2,3,4,7)) --GROUP BY TimeGroup --ORDER BY TimeGroup JOINOPTIMIZECOSTS
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 ? ![]() |