Select, separated by commas, the fields in a many-to-many relationship

gistfile1.sql

SELECT DISTINCT Cadastro.id, Cadastro.nome,

     STUFF(
         (SELECT ', ' +  Area.nome 
          FROM Area_Cadastro, Area  
          WHERE Cadastro.ID = Area_Cadastro.cadastro_id AND Area_Cadastro.area_id = Area.id
          FOR XML PATH (''))
          , 1, 1, '')  AS areas

FROM Cadastro 
LEFT JOIN Area_Cadastro ON (Cadastro.ID = Area_Cadastro.cadastro_id)
LEFT JOIN Area ON (Area_Cadastro.area_id = Area.id)

GROUP BY Cadastro.id, Cadastro.nome, Area.nome