title: group concat and in clause
body: <p>Hi have two tables named  Roles and jobs respectivly<a href="https://i.stack.imgur.com/6nKzA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6nKzA.png" alt="jobs table structure"></a></p>
  
  <p><a href="https://i.stack.imgur.com/NkyPz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NkyPz.png" alt="Roles table structure"></a></p>
  
  <p>and when in  run the below query </p>
  
  <pre><code>SELECT job_id ,GROUP_CONCAT(roles_title) from jobs left join roles on roles_id in (roles) group by job_id 
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/2iagX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2iagX.png" alt="Result i got"></a></p>
  
  <p>Expected Result</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="false" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;table&gt;
    &lt;tr&gt;
      &lt;td&gt;Job_id&lt;/td&gt;
      &lt;td&gt;Roles&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td&gt;1&lt;/td&gt;
      &lt;td&gt;Admin,acc &amp; test&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td&gt;2&lt;/td&gt;
      &lt;td&gt;acc&amp; test&lt;/td&gt;
    &lt;/tr&gt;
  &lt;/table&gt;</code></pre>
  </div>
  </div>
  </p>