title: SQL Query Distinct Column Concatenate Other Column
body: <p>I have a MS SQL query that joins multiple tables and an example of the results are:</p>
  
  <pre><code>EmailAddress          Column2                                      
  --------------------- ----------------
  sean@abc.com          Value1                                     
  sean@abc.com          Value2
  test@abc.com          Value5 
  
  
  What I really want to achieve are the following results:
  
  
  EmailAddress          Column2                                      
  --------------------- ------------------
  sean@abc.com          Value1, Value2
  test@abc.com          Value5 
  </code></pre>
  
  <p>There are other columns that are identical for each row with the same email address. Can anyone help me with the SQL to return distinct email addresses and concatenate the column2 information? </p>
  
  <p>Thanks for any feedback. </p>