title: Comma separated MYSQL CONCAT from 2 tables
body: <p>How to you group concat 2 simple tables so the the output is:</p>
  <pre><code>John | One, Two
  Luke | One, Two
  </code></pre>
  <p>I have seem some other examples, but I don't appear to make sense of it. Im a complete NOOB</p>
  <p>users table</p>
  <pre><code>|name|names|
  |John|001|
  |John|002|
  |Luke|001|
  |Luke|002|
  </code></pre>
  <p>servers table</p>
  <pre><code>|id|name|
  |001|One|
  |002|Two|
  </code></pre>
  <p>MYSQL statement</p>
  <pre><code>SELECT *
  FROM users 
  INNER JOIN servers 
  ON users.names = servers.names
  </code></pre>
  <p>Produces:</p>
  <pre><code>John | One
  John | Two
  Luke | One
  Luke | Two
  </code></pre>