![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.05 » View Incident Report |
![]() |
Reported By: Kevin Koehne Reported On: 9/26/2011 For: Version 2.05 Build 11 |
Select Advertisement, Count(Distinct ResNumber) from tblguestdates dates inner join tblguestgeneral gen on dates.resnumber = gen.resnumber inner join tblguestroomrates rates on gen.Resnumber = rates.resnumber Where ResDate >= Date '2011-9-25' and ResDate <= Date '2011-9-26' and dates.Cancelled is Null Group By Advertisement And here is the result Advertisement Count of ResNumber 0 6 1 3 3 1 4 30 5 6 7 12 9 1 16 1
This web page was last updated on Tuesday, June 3, 2025 at 08:21 AM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |