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