title: Change a MySql Select/Inner-Join with Group By into an Update?
body: <p>I am doing an Inner-Join between two tables to try to create a Group_Concat from the first Table:</p>
  
  <pre><code>SELECT GROUP_CONCAT(concat('!"',LJ.Name1,'"') separator ' ') FROM `Table1` BC
  Inner Join `Table2` LJ
  On LJ.Name like concat(BC.Name,' %')
  and LJ.Field_S=BC.Field_S
  Where LJ.Type='Person'
  Group by BC.Field_S,BC.Name`
  </code></pre>
  
  <p>The problem is when I try to make this an <code>Update</code>as is the purpose MySql does not like the <code>Group By</code> apparently inside an <code>Update</code>.</p>
  
  <p><a href="http://sqlfiddle.com/" rel="nofollow noreferrer">SqlFiddle</a> seems to be down so I can't make an example until I can find an alternative but in the interim was wondering if there is some "standard" way of converting this kind of <code>Select Inner Join</code> into an <code>Update Inner Join</code>.</p>