title: SQL statement to join and give result in multiple columns
body: <p>Can anyone help me with an sql statement to produce te following result?</p>
  
  <pre><code>Table Person
  Person_ID  Name
  1          John
  2          Paul
  
  Table Declaration
  Decl_ID             Person_ID   Amount
  1                   1               10
  2                   2               12
  3                   1               99
  4                   1               24
  </code></pre>
  
  <p>Result of the SQL statment should look like this:</p>
  
  <pre><code>Name    Amount1 Amount2 Amount3
  John    10      99      24
  Paul    12
  </code></pre>