title: SQL - JOIN statement creating duplicate entries
body: <p>I am new to SQL and I am running into trouble.</p>
  <p>I have 3 tables:</p>
  <pre><code>CREATE TABLE indexCodes 
  {
     (indexNum VARCHAR(5) PRIMARY KEY, 
     courseString VARCHAR(10), 
     title VARCHAR(20)
  }
  
  CREATE TABLE userid
  {
       (id  INT NOT NULL PRIMARY KEY AUTO_INCREMENT, 
       email VARCHAR(255) NOT NULL, 
       password VARCHAR(255) NOT NULL)
  }
  
      CREATE TABLE snipes
  { 
        (snipeNumber  INT NOT NULL PRIMARY KEY AUTO_INCREMENT), 
         FOREIGN KEY indexNum REFERENCES indexcodes(indexNum),
         FOREIGN KEY userID REFERENCES userid(id)
  }
  </code></pre>
  <p>Using the JOIN statement</p>
  <pre><code>SELECT  userid.id, userID.email, snipes.indexNum, indexcodes.courseString, == indexcodes.title
  FROM userid JOIN
       snipes JOIN
       indexcodes ON indexcodes.indexNum = snipes.indexNum 
  </code></pre>
  <p>I run into duplicate entries.
  For example, an indexcode inserted based on one user shows an index for all users</p>