Comma separated list from mapping table as an embedded SELECT statement

Ever needed to get a comma seperated list instead of another mapping table? Well in these days of Linq this may be old hat - but it's still nice to remember how to do it. Here's a quick and easy way to get a list from a linked table constructing the list field using the XML PATH features of SQL Server 2005:

(SELECT CAST(CountryId AS NVARCHAR(10)) + ',' AS [text()]
     FROM UserToCountryMapping AS utcm
    WHERE utcm.UserId = externalSelectTable.UserId
     FOR XML PATH('')) as Regions