title: Using INNER JOIN multiplies selected rows?
body: <p>There are alot of posts on inner joins but not sure if it quite answers my problem? </p>
  
  <p>I have four tables I wish to join in which the first three seem correct, its when I join the 4th table the join multiplies rows (table AB * table C).    </p>
  
  <p>The 4th table only has 37 rows however each row would need to be specifically inserted  several times according to the viewunitsonrun.strUnitCode which are repeated several times in the 1st table (tblawardedlearers).  </p>
  
  <pre><code>SELECT viewlearnersonrun.intRunID,
         intlearnerID,
         strFirstname, 
         strunitcode, 
         strGrade
    FROM tblawardedlearners
   INNER JOIN viewlearnersonrun
           ON viewlearnersonrun.intID = tblawardedlearners.intLearnerID
   INNER JOIN viewrun
           ON viewrun.intID = viewlearnersonrun.intRunID /*CORRECT TO THIS POINT */
   INNER JOIN viewunitsonrun
           ON viewunitsonrun.strUnitCode = tblawardedlearners.strUnitCode 
   WHERE viewlearnersonrun.intRunID = '200GE2'   /* display only one Course */
  </code></pre>