title: postgresql inner join to string join together
body: <p>I have the below query</p>
  <pre><code>SELECT 
  CCTP.C5NCCT AS &quot;Numéro&quot;,
  CCTSPEP.CBCSPE AS &quot;Spécialité&quot;
  FROM FIC.CCTP CCTP
  LEFT JOIN FIC.CCTSPEP CCTSPEP ON CCTSPEP.CBNCCT = CCTP.C5NCCT;
  </code></pre>
  <p>which returns this result</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Numéro</th>
  <th>Spécialité</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>01</td>
  </tr>
  <tr>
  <td>1</td>
  <td>24</td>
  </tr>
  <tr>
  <td>1</td>
  <td>25</td>
  </tr>
  <tr>
  <td>2</td>
  <td>02</td>
  </tr>
  <tr>
  <td>2</td>
  <td>06</td>
  </tr>
  <tr>
  <td>3</td>
  <td>11</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I want to update the query to get a result similar to this</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Numéro</th>
  <th>Spécialité</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>01, 24, 25</td>
  </tr>
  <tr>
  <td>2</td>
  <td>02, 06</td>
  </tr>
  <tr>
  <td>3</td>
  <td>11</td>
  </tr>
  </tbody>
  </table>
  </div>