>SELECT tlp.PersonID, tlp.Program, > ( SELECT COUNT(*) FROM dbo.tmmLicesnses2Persons tlp2 > WHERE tlp2.Program = tlp.Program > AND (DateActivated IS NOT NULL) AND (DateDeactivated IS NULL)) AS ProgramCount > FROM dbo.tmmLicesnses2Persons tlp > WHERE (DateActivated IS NOT NULL) AND (DateDeactivated IS NULL) > GROUP BY PersonID, Program >>>>
>>>SELECT PersonID, Program, COUNT(*) AS ProgramCount >>>FROM dbo.tmmLicesnses2Persons >>>WHERE (DateActivated IS NOT NULL) AND (DateDeactivated IS NULL) >>>GROUP BY PersonID, Program >>>>>