SQL subquery return multiple values

Please look at my query

select tms.TeamName,
(select loc.LocID from Locations loc, Users usr where loc.UserID = usr.UserID and usr.TeamID = tms开发者_JS百科.TeamID)
from Teams tms

In this case LocID returns multiple values. I want it to come in single column with comma separated values. How can i proceed?

Thanks in advance - Manoj

select
  tms.TeamName,
  stuff(
    (select ','+cast(loc.LocID as varchar(10))
     from Locations as loc
      inner join Users as usr
        on loc.UserID = usr.UserID
     where usr.TeamID = tms.TeamID
     for xml path('')), 1, 1, '')
from Teams as tms