Inner Join MySQL duplicates
Posted: Thu Oct 23, 2008 4:40 pm
The following creates MySQL duplicates...
The output looks like this...

Code: Select all
SELECT `name`FROM game_categoryINNER JOIN games ON game_category.game_id = game_idWHERE game_category.category_id = '2'...I'm not sure what I'm doing incorrectly. I'm executing this code straight through phpMyAdmin. I added describe at the beginning and the table and all I see are simple, all, and null for columns I haven't chosen? How can I improve my query so I only get the results once please? Changing the tag number (at the end of the query) seems to have an effect on how many times the results are duplicated though I'm not seeing any "AH-HA!" patterns.Football Fanatics 2009
Angry Gopher Golfers
Destroy All Humans
Heroes of Might & Magic III
Diablo II
Football Fanatics 2009
Angry Gopher Golfers
Destroy All Humans
Heroes of Might & Magic III
Diablo II
Football Fanatics 2009
Angry Gopher Golfers
Destroy All Humans
Heroes of Might & Magic III
Diablo II
Football Fanatics 2009
Angry Gopher Golfers
Destroy All Humans
Heroes of Might & Magic III
Diablo II
Football Fanatics 2009
Angry Gopher Golfers
Destroy All Humans
Heroes of Might & Magic III
Diablo II
Football Fanatics 2009
Angry Gopher Golfers
Destroy All Humans
Heroes of Might & Magic III
Diablo II