title: Firebird SQL join tables
body: <p>Currently I have tables like these:</p>
  
  <p>Table Customer</p>
  
  <pre><code>ID      Name
  01      Angel
  02      Charlie
  </code></pre>
  
  <p>Table Input1</p>
  
  <pre><code>Name     Value
  Charlie  5
  Angel    7
  Charlie  10
  Angel    3
  </code></pre>
  
  <p>Table Input2</p>
  
  <pre><code>Name     Value
  Charlie  10
  Angel    5
  Charlie  15
  Angel    25
  </code></pre>
  
  <p>How to get result like this</p>
  
  <pre><code>Name     Input1     Input2
  Angel    10         30
  Charlie  15         25
  </code></pre>