Using derived tables

	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
>>

>
>This returns:
>
>1 P1 1
>1 P2 1
>2 P1 1
>2 P2 1
>3 P2 1
>3 P3 1
>3 P4 1
>3 P5 1
>
>What I need is:
>
>1 P1 2
>1 P2 3
>2 P1 2
>2 P2 3
>3 P2 3
>3 P3 1
>3 P4 1
>3 P5 1