title: Concat child records in parent SELECT
body: <p>To my best knowledge of MySQL this not a possible thought in this case would be helpful. </p>
  
  <p>We want to <code>select</code> a record in a parent table and concat (something like that) the child rows in the  <code>select</code>. Here in obviously wrong MySQL but to illustrate what we want to achieve. </p>
  
  <pre><code>SELECT parentattr, 
         CONCAT (
                 SELECT name 
                 FROM child 
                 WHERE child.parentId = parent.id)) as allchildernames
  FROM parent
  </code></pre>