title: Inner join returning large numbers of duplicates
body: <p>I am using the following query to join two tables together: </p>
  
  <pre><code>SELECT SDA.smachIPAddress,
  DPP.ScanName,
  DPP.pspplMSSeverity,
  DPP.PatchMissing,
  DPP.ScanDate
  FROM patchtest_withsev DPP
  INNER JOIN patchtest_withip SDA
  ON DPP.ScanName =SDA.ScanName
  </code></pre>
  
  <p>and receiving 2351 rows of data</p>
  
  <p>When I query the patchtest_withsev table for all records it only returns 99 and the patchtest_withip table only returns 99.</p>
  
  <p>Can anyone see why this query is producing such a large mismatch?</p>