title: SQL concat rows table2 into column table1
body: <pre><code>Table1
  +----+--------------+
  | id |   csvalues   |
  +----+--------------+
  |  1 |    100;1001; |
  |  3 |    300;12;   |
  |  4 |    400;44;   |
  +----+--------------+
  
  
  Table2
  +----+----------+--------+
  | id | csvalues2|table1ID|
  +----+----------+--------+
  |  1 |  10      |    1   |
  |  3 |  30      |    1   |
  |  4 |   111    |    3   |
  +----+----------+--------+
  </code></pre>
  
  <p>There are these 2 tables.
  I wan't to get a result like this</p>
  
  <pre><code>RESULT
  +----+----------------+
  | id |   csvalues     |
  +----+----------------+
  |  1 |100;1001;10;30; |
  |  3 |300;12;111;     |
  +----+----------------+
  </code></pre>
  
  <p>Is it possible? I tried to Left Join the tables but can't get the Table2.csvalues2 into RESULT.csvalues.</p>