I am new to SQL and I am running into trouble.

I have 3 tables:

```
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)
}

```

Using the JOIN statement

```
SELECT  userid.id, userID.email, snipes.indexNum, indexcodes.courseString, == indexcodes.title
FROM userid JOIN
     snipes JOIN
     indexcodes ON indexcodes.indexNum = snipes.indexNum 

```

I run into duplicate entries.
For example, an indexcode inserted based on one user shows an index for all users