title: Concatenate values from column in related table into a string
body: <p>I have 2 tables (1-n) in <strong>SQL Server 2008</strong>.</p>
  
  <p>Example: 1 person - 'n' addresses</p>
  
  <p>I want to select persons data and bring related addresses districts into a column (concatenated)</p>
  
  <pre><code>ID  Name
  ------------------------------------------
  1   John Smith
  2   Daniel
  
  PersonID  DistrictName
  ------------------------------------------
  1         Brooklin
  1         SoHo
  2         Upper West Side
  2         Harlem
  
  SELECT desired
  ------------------------------------------
  John Smith   Brooklin, SoHo
  Daniel       Upper West Side, Harlem
  </code></pre>
  
  <p>How could I do this in tsql?</p>