On...Let me explain better.  The UserId = 195 has 3 records (1 Completed and 2 Open) in the tblRequest table (req).  When I run this query below, I get a count...

This query returns the data that i need,  but does not have the Id filter from tblImplementer.

SELECT     cs.Name, COUNT(req.RequestId) AS Total

FROM         dbo.tblRequest req RIGHT OUTER JOIN

                      dbo.tblChangeStatus cs ON req.ChangeStatusId...