title: MS Access 2010 query returns more rows than in table
body: <p>I have a query in MS Access 2010 which returns more rows than there are in the source table. </p>
  
  <p>I have tried to recreate what is happening with a simplified example, but could not get the same effect. I have set the parameters so that all records in the source table should be included, but only those that match from the other tables.</p>
  
  <p>The <code>tbl_Toyota2012</code> has 178'205 records... the result of the query returns 180'365 records.</p>
  
  <p>Here is my SQL code:</p>
  
  <pre><code>SELECT 
     tbl_Toyota2012.[FC-Teile-Nr], tbl_Toyota2012.BEZEICHNUNG, tbl_Toyota2012.PFC, 
     tbl_Toyota2012.PC, tbl_Toyota2012.WARENGRUPPE, tbl_PriceCodes.PRICE_CODE, 
     tbl_PriceCodes.NORMAL_FACTOR, tbl_Toyota2012.EK_NETTO_MANDANT AS EP, 
     tbl_Toyota2012.UPE, tbl_Toyota2012.RABATTSATZ, tbl_NWGW_Key.ZUTEILUNG, 
     tbl_Toyota2012.UMSATZ_2012_UNITS AS [Volumen 2012], 
     [tbl_Toyota2012]![UMSATZ_2012_UNITS]*[tbl_Toyota2012]![UPE]*(1-([tbl_Toyota2012]![RABATTSATZ]/100)) AS NettoUmsatz
  
  FROM 
     (tbl_Toyota2012 
  LEFT JOIN 
     tbl_NWGW_Key ON (tbl_Toyota2012.PC = tbl_NWGW_Key.ProdCode) AND (tbl_Toyota2012.PFC = tbl_NWGW_Key.PFC)) 
  LEFT JOIN 
     tbl_PriceCodes ON (tbl_Toyota2012.MODELL_ID = tbl_PriceCodes.MODEL_ID) AND (tbl_Toyota2012.PC = tbl_PriceCodes.PROD_CODE) AND (tbl_Toyota2012.PFC = tbl_PriceCodes.PROD_FUNC_CODE);
  </code></pre>
  
  <p>Can anyone tell me why this might happen?</p>