title: How to create a query to join multiple rows from a different table into single comma delimated column in SQL Server
body: <p>I am using SQL Server 2014, and I have two tables:</p>
  
  <pre><code>number        id
  ------------------
  36-23         1
  36-23         2
  
  id         value
  ------------------
  1          asia   
  2          europe         
  </code></pre>
  
  <p>The <code>number</code> column is of type <code>varchar</code>. I want to write a query to return the following results:</p>
  
  <pre><code>number       Name   
  ---------------------------
  36-23        asia,europe
  </code></pre>
  
  <p>I am wondering how can I do this with the help of query or functions in SQL Server.</p>