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
Alex Martino
367 PointsFirst Question of Inner Join...I don't understand.
Why doesn't this code below work? The quiz keeps saying it's not right but the results look ok.
SELECT movies.title, genres.name FROM movies LEFT OUTER JOIN genres ON movies.id= genres.id;
1 Answer
Tim Knight
28,888 PointsAlex,
You don't want to join on the movies.id field because that's not going to match the genres.id field. You instead want to use the movies.genre_id foreign key here, so it would actually be something like:
SELECT movies.title, genres.name
FROM movies
INNER JOIN genres
ON movies.genre_id = genres.id;