title: Incorrect sum when I join a second table
body: <p>This is the first time I ask for your help,</p>
  
  <p>Actually I have to create a query, and did a similar example for it. I have two tables, </p>
  
  <pre><code>Report (ReportID, Date, headCount)
  Production(ProdID, ReportID, Quantity)
  </code></pre>
  
  <p>My question is using this query, I get a wrong result, </p>
  
  <pre><code>SELECT    
      Report.date, 
      SUM(Report.HeadCount) AS SumHeadCount, 
      SUM(Production.Quantity) AS SumQuantity
  FROM         
      Report 
  INNER JOIN
      Production ON Report.ReportID = Production.ReportID
  GROUP BY
      Date
  ORDER BY
      Date
  </code></pre>
  
  <p>I guess some rows are being counted more than once, could you please give me a hand?</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>if i run a query to get a sum of headcount grouped by day, I get:</p>
  
  <pre><code>  date        Headcount
  7/2/2012    1843
  7/3/2012    1802
  7/4/2012    1858
  7/5/2012    1904
  </code></pre>
  
  <p>also for Production Qty I get:</p>
  
  <pre><code>2012-07-02  8362
  2012-07-03  8042
  2012-07-04  8272
  2012-07-05  9227
  </code></pre>
  
  <p>but when i combine the both queries i get i false one, i expect on 2 july 8362 qty against 1843, but i get:</p>
  
  <pre><code> day      TotalHeadcount    totalQty
  7/2/2012    6021    8362
  7/3/2012    7193    8042
  7/4/2012    6988    8272
  7/5/2012    7197    9227
  </code></pre>