# 3 Table Join? **URL:** \ **Category:** Uncategorized\ **Created:** [April 27, 2007, 12:09am UTC](https://forum.kirupa.com/t/3-table-join/223946 "2007-04-27T00:09:03Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![stickaforkinit](https://avatars.discourse-cdn.com/v4/letter/s/e0b2c6/32.png) [@stickaforkinit](https://forum.kirupa.com/u/stickaforkinit)\ **Post date:** [April 27, 2007, 12:09am UTC](https://forum.kirupa.com/t/3-table-join/223946/1 "2007-04-27T00:09:03Z")
Tables are as follows: grades gr\_id | gr\_name 1 pre-school 2 Grade 1 … … product pr\_id | pr\_name | pr\_url 1 Activity activity.swf 2 Weather weather.swf … product\_grades pg\_id | pg\_product | pg\_grade 1 1 2 2 2 1 … I need the output to be the following Activity Book Pre-school, Grade 1, kindergarten Weather Maker Grade 5, Grade 4, Grade 3 Without the product name being printed out more than once I have this sql statement but it print out product names for each grade instead of just one product name and multiple grades Activity Book Pre-school Activity Book Grade 1 Activity Book Kindergarten Weather Maker Grade 5 Weather Maker Grade 4 Weather Maker Grade 3 $sql=“SELECT product.pr\_id, product.pr\_name, product\_grades.pg\_grade, product\_grades.pg\_product, grades.gr\_id, grades.gr\_name FROM ( product INNER JOIN product\_grades ON product.pr\_id = product\_grades.pg\_product ) INNER JOIN grades ON product\_grades.pg\_grade=grades.gr\_id ORDER BY product.pr\_name”; Help would be appreciated. Thanks for any help given.