SELECT dt1.PersonID, dt1.Program, dt2.ProgramCount FROM (SELECT DISTINCT PersonID, Program FROM tmmLicesnses2Persons WHERE (DateActivated IS NOT NULL) AND (DateDeactivated IS NULL)) dt1 JOIN (SELECT COUNT(*) AS ProgramCount FROM dbo.tmmLicesnses2Persons WHERE (DateActivated IS NOT NULL) AND (DateDeactivated IS NULL) GROUP BY Program) dt2 ON dt1.Program = dt2.Program>>
>>SELECT PersonID, Program, COUNT(*) AS ProgramCount >>FROM dbo.tmmLicesnses2Persons >>WHERE (DateActivated IS NOT NULL) AND (DateDeactivated IS NULL) >>GROUP BY PersonID, Program >>>