Help With Query

Question

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.

gregg 0 · Answer

I got it if anyone is interested. SELECT dbo.PriorityLevels.Priority COUNT(dbo.Issues.PriorityId) AS theCount FROM dbo.Issues INNER JOIN dbo.PriorityLevels ON dbo.Issues.PriorityId = dbo.PriorityLevels.Id GROUP BY dbo.PriorityLevels.Priority dbo.Issues.PriorityId