title: How to join three row of result from a join one to many to multiple columns
body: <p>I have to get the three first results of a one to many join. 
  For example </p>
  
  <pre><code>JOIN `company`.`Reason`
    ON ((`company`.`Reason`.`quality_id` = `company`.`Quality`.`id`)))
  </code></pre>
  
  <p>where Quality has a one to many relation to Reason.</p>
  
  <p>And I need to show in a column REASON_1 the first result from Reason, in REASON_2 the second and REASON_3 the third.</p>
  
  <p>At the moment, I show only one row of result this way : </p>
  
  <pre><code>  `company`.`Reason`.`status`                                                AS `Reason`
  </code></pre>
  
  <p>And I don't know how this works, how does it select one row, and which one ?<br>
  And how can I do the same, but only with 3 rows and with different column name ? </p>
  
  <p>Quality</p>
  
  <pre><code>ID | a  | b
  1  | a1 | b1 
  2  | a2 | b2
  </code></pre>
  
  <p>Reason</p>
  
  <pre><code>ID | quality_id  | status
  1  | quality_id_1 | status_1 
  2  | quality_id_1 | status_2
  2  | quality_id_2 | status_1
  2  | quality_id_2 | status_3
  </code></pre>
  
  <p>So if I want to get Reasons of Quality of id 1 I would get</p>
  
  <pre><code>REASON_1 | REASON_2 | REASON_3
  status_1 | status_2 | null
  </code></pre>