title: Total amount of financing already provided to each customer
body: <p>I have three separate tables: </p>
  
  <pre><code>SystemA_Cash
  SystemA_Loans 
  SystemB_CarLoans
  </code></pre>
  
  <p>Each table has <code>Cash_AdvanceID</code> field, <code>Customer</code>, &amp; <code>Funded Amount</code>.</p>
  
  <p>I need to total the amount funded for each customer.</p>
  
  <p>Each customer can be present in any of the tables too.</p>
  
  <p>So far I did</p>
  
  <pre><code>SELECT SystemA_CashAdvances.CashAdvanceID, SystemA_CashAdvances.Customer, 
  SystemA_CashAdvances.Funded_Amount 
  FROM 
  SystemA_CashAdvances
  INNER JOIN
  SystemA_Loans ON SystemA_Loans.CashAdvanceID = SystemA_CashAdvances.Cash_AdvanceID
  INNER JOIN
  SytemB_CarLoans ON SystemA_CashAdvances.Cash_AdvanceID = SystemB_CarLoans.CashAdvanceID;
  </code></pre>
  
  <p>It doesn't seem to return one table with the customers and the total amount each was funded.</p>