title: SQL SELECT - group multiple values on a single row
body: <p>I have a table with the following data:</p>
  
  <pre><code>ID  CAT  TYPE   SUBPRODUCT
  --- ---- ------ ----------------
  1   1     1       AA
  2   1     1       BB
  3   1     2       CC
  </code></pre>
  
  <p>I'd like to get the data like this:</p>
  
  <pre><code>CAT   TYPE   SUBPRODUCT
  ----- ------ ---------------
  1     1      AA,BB
  1     2      CC
  </code></pre>
  
  <p>pls reply me what should i do.</p>
  
  <p>Thanks.</p>