title: How do I join two table on a column and group by on another column
body: <p>Lets say I have two franchise of dance schools.</p>
  <p>I have two tables. First table tells about students roll no. every</p>
  <p>Table 1 =</p>
  <pre><code>Roll No.    Center ID   Name    Date
  1   A   Anna    10/10/2020
  1   A   Anna    11/10/2020
  1   B   Anna    12/10/2020
  2   A   Bella   12/10/2020
  2   B   Bella   13/10/2020
  3   A   Catty   10/10/2020
  </code></pre>
  <p>Table 2 =</p>
  <pre><code>Roll no.    Center ID   Report
  1   A   Did well
  1   A   Sick 
  1   B   Needs more twist
  2   A   Practice required
  2   B   Did well
  3   A   Needs more practice
  </code></pre>
  <p>Result table expected: I want in the result it should pick Center id as A only but Report should be from both the centers</p>
  <pre><code>Roll no.    Center ID   Report  Name
  1   A   Did well ,Sick ,Needs more twist    Anna
  2   A   Practice required,Did well  Bella
  3   A   Needs more practice Catty
  </code></pre>
  <p>Could someone pls help.</p>