title: how to select one row from one table and multiple rows from other table using joins in mysql,
body: <p>I searched google and everything all are explained using joins but i dont need duplicate data of the first table, I want single row from first table.</p>
  
  <p>consider table a has two column id and name</p>
  
  <pre><code>id | name
  
  1  | jhon
  
  2  | rock
  </code></pre>
  
  <p>and table b has two column id which is foreign key referencing table a's id and place</p>
  
  <pre><code>id | nickname
  
  1  | steve
  
  1  | smith
  
  2  | kiran
  </code></pre>
  
  <p>And i want out put as</p>
  
  <pre><code>id | name | nickname
  
  1  | jhon | steve
  
            | smith
  </code></pre>