title: How to display SUM fields from a detailed table in a master table
body: <p>What is the best approach to display the summery of DETAILED.Fields in its master table?</p>
  
  <p>E.g. I have a master table called 'BILL' with all the bill related data and a detailed table ('BILL_DETAIL') with the bill detailed related data, like NAME, PRICE, TAX, ... Now I want to list all BILLS, <strong>without the details</strong>, but with the <strong>sum</strong> of the PRICE and TAX stored in the detail table.</p>
  
  <p>Here is a simplified schema of that tables:</p>
  
  <pre><code>TABLE BILL
  ----------
  - ID
  - NAME
  - ADDRESS
  - ...
  
  TABLE BILL_DETAIL
  -----------------
  - ID
  - BILLID
  - PORDUCT_NAME
  - PRICE
  - TAX
  - ...
  </code></pre>
  
  <p>The retrieved table row should look like this:</p>
  
  <pre><code>BILL.CUSTOMER_NAME, BILL.CUSTOMER_ADDRESS, sum(BILL_DETAIL.PRICE), sum(BILL.DETAIL.TAX), ...
  </code></pre>
  
  <p>Any sugguestions?</p>