title: SQL Concatenate multiple rows
body: <p>I'm using Teradata, I have a table like this</p>
  
  <pre><code>ID       String
  123      Jim
  123      John
  123      Jane
  321      Jill
  321      Janine
  321      Johan
  </code></pre>
  
  <p>I want to query the table so I get </p>
  
  <pre><code>ID       String
  123      Jim, John, Jane
  321      Jill, Janine, Johan
  </code></pre>
  
  <p>I tried partition but there can be many names.
  How do I get this result. Even, to point me in the right direction would be great. </p>