title: Get records of a table which exists in another table distinct field in MySQL
body: <p>I have two tables</p>
  <p><strong>land_information</strong></p>
  <pre><code>id  | title_number   | owner      | case_no
  1     001              John          201
  2     002              Peter         202
  3     002              Andrew        203
  4     003              Mores         204
  </code></pre>
  <p><strong>sheets</strong></p>
  <pre><code>id   | title_number
  1      001
  2      001
  3      002
  4      NULL
  5      Unavailable
  </code></pre>
  <p>Now, I need to check if <code>title_number</code> of sheets table exists in land_information.</p>
  <p>How should I make a query which will result like the expected result below.</p>
  <p>Expected Result</p>
  <pre><code>id   title_number     owner           case_no
   1      001          John                201
   3      002          Peter, Andrew       202, 203
  </code></pre>
  <p>Here is my initial sql.</p>
  <pre><code>SELECT id, 
         li.title_number, 
         owner 
  FROM sheets AS s 
  INNER JOIN land_information AS li ON s.title_number = li.title_number;
   
  </code></pre>