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

Development Tools Database Foundations Joining Relational Data Between Tables in SQL Joining Tables and Aliasing

Posted by Becca Ades
Becca Ades
4,205 Points

I'm unclear as to why my code isn't working for joining inner tables!

Here is my code:

SELECT movies.title, genres.name FROM movies INNER JOIN genres ON movies.title = genres.name;

Thanks!

1 Answer

Alex Hedley
Alex Hedley
16,381 Points
Alex Hedley
Alex Hedley
16,381 Points

You need to join on the Primary/Foreign Keys which are the IDs:

SELECT movies.title, genres.name FROM movies INNER JOIN genres ON movies.genre_id = genres.id
David Axelrod
David Axelrod
36,073 Points
David Axelrod
David Axelrod
36,073 Points

Ahhh now i get it. I was mixing up my keys and which column belonged to which