Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

PHP Integrating PHP with Databases Filtering Input for Queries Multiple Conditionals

Posted by Magnus Martin
Magnus Martin
44,123 Points

Task 2 Many to Many relationship

Could anybody give some advise what to do in Task 2? Are there 2 inner joins necessary?

1 Answer

Ben Payne
Ben Payne
1,464 Points
Ben Payne
Ben Payne
1,464 Points

Hey Magnus - You do need two joins. You'll need to join first on the intermediate table Media_People using the people_id column from People then use the media_id column from Media_People to join on Media using media_id. I can post the correct statement if you can't get it.

Cheers

_Ben