title: Summing Detail records in Master Detail SQL Statement
body: <p>I have two tables</p>
  
  <pre><code>Master  
  Detail
  </code></pre>
  
  <p>In the Master &amp; Detail table, i have an <code>Amount</code> field</p>
  
  <p>I need to get the SUM of Amount in Detail and subtract it from Amount in Master and display in "Current_Amount"</p>
  
  <p>"Current_Amount" should equal to  "Master.Amount" - Sum of "Detail.Amount"</p>