Help With Query

[goduke]

I am using SQL Server 2005 and have very basic SQL skills.

I am creating a simple view that shows leaders of a company and then I join on a leader view to cout the number of associates that are under that leader. Each associate that reports to a particular leader has a location country. What I want to do is show the leader's name, a count of how many associates they have, and then a third field that has a comma delimited list of all the DISTINCT countries that those associates are in. I was thinking that I may have to use a CTE, but not too familiar with those. There may be an easier way, but I wasnt sure. I have all but the last part. Below is my code and my results.

--this gets me my data before I count and group--
select ai1.full_name, ai2.full_name, lc.location_country
from associate_info ai1
inner join super_rpt_leader_view sr
on ai1.emplid = sr.leader_emplid
inner join associate_info ai2
on sr.emplid = ai2.emplid
inner join location_code lc
on ai2.location_id = lc.location_id
order by ai1.full_name

--sample results--
clint mears dawn england USA
clint mears justin harper GBR
clint mears fred davis USA
clint mears jennifer davis POL

--this will be when i add the group--
select ai1.full_name, count(ai2.full_name) as Employees
from associate_info ai1
inner join super_rpt_leader_view sr
on ai1.emplid = sr.leader_emplid
inner join associate_info ai2
on sr.emplid = ai2.emplid
inner join location_code lc
on ai2.location_id = lc.location_id
group by ai1.full_name

--sample results--
clint mears 4

--what I would like to see--
clint mears 4 USA,GBR,POL

Any help would be great. Thanks guys!