I need some help building a query. I have an issue table that, among other things, stores a PriorityLevelId. I have a Priority Table that just has 2 columns, Id and Level. PriorityLevelId is a foreign key to the Id column in the Priority Table. There are only 3 types of priorites. Minor, Hendering, and Halting.
What I need is a query that will get a total of each priority type for a given day (say today) and return those to me with the corosponding type. So something like
Minor 21
Hendering 32
Halting 15
I am using MS SQL Server 2000. Can someone give me a hand with this?
Thanks.