title: Show a one to many relationship as 2 columns - 1 unique row (ID & comma separated list)
body: <p>I need something similar to these 2 SO questions, but using Informix SQL syntax.  </p>
  
  <ul>
  <li><p><a href="https://stackoverflow.com/questions/37696/concatenate-several-fields-into-one-with-sql">Concatenate several fields into one with SQL</a></p></li>
  <li><p><a href="https://stackoverflow.com/questions/368459/sql-help-select-statement-concatenate-a-one-to-many-relationship">SQL Help: Select statement Concatenate a One to Many relationship</a></p></li>
  </ul>
  
  <p>My data coming in looks like this:</p>
  
  <pre><code>id     codes
  
  63592  PELL
  58640  SUBL
  58640  USBL
  73571  PELL
  73571  USBL
  73571  SUBL
  </code></pre>
  
  <p>I want to see it come back like this:</p>
  
  <pre><code>id     codes 
  
  63592  PELL
  58640  SUBL, USBL
  73571  PELL, USBL, SUBL
  </code></pre>
  
  <p>See also <a href="https://stackoverflow.com/questions/489081/groupconcat-in-informix/">group_concat() in Informix</a>.</p>