title: SQL Query in an 1:N relationship
body: <p>I have the following database, it's a simple relationship between an user and his receipts:</p>
  
  <p><a href="https://i.stack.imgur.com/c8BQE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/c8BQE.png" alt="Database"></a></p>
  
  <p>I need to get as many row as users and so many column as much receipt it have. For example:</p>
  
  <p>If user 1 have 2 receipt I have to obtain:</p>
  
  <pre><code>IdUser   Receipt 1    Receipt 2
    1         12€          13€
  </code></pre>
  
  <p>I tried with an inner joint between User and Receipt tables, but I have as many rows users as receipts they have.</p>
  
  <p><strong>EDIT</strong></p>
  
  <pre><code>SELECT user.idUser, receipt.value
  FROM user INNER JOIN receipt ON user.IdUser = receipt.IdUser;
  </code></pre>