>Select Zone,Class,count(*) From Table1 Group by Zone,Class
Ok, that works great. Mind if I add one more level of complication? :)
The one thing this won't list is zones with a count of 0. This makes sense because if that zone isn't in the table, the computer won't even know it exists. There is another table called "Zones" that lists all the zones. Is there a way to tack this on to the SQL so that it does it's count including zones that occur in the zones table but not the other table?
Thanks,
-Michelle
Oh, P.S. I don't want it to _only_ do ones from the zones table because then it won't catch all the ones where the dispatcher typed in the zone wrong, as your SQL does so nicely. :)
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only