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
Bularca Andrei
2,408 PointsJoining 2 tables ...
SELECT movies.title , genres.name FROM movies INNER JOIN genres ON movies genre_id=genres,id ;
FAIL ...
2 Answers
Vedran Brnjetić
6,004 PointsOh, right, sorry, you're also missing a dot between movies and genre_id
so:
SELECT movies.title , genres.name FROM movies INNER JOIN genres ON movies.genre_id=genres.id ;
Vedran Brnjetić
6,004 PointsYou have a comma instead of a dot at genre_id=genres,id
Bularca Andrei
2,408 PointsFAIL ...
Vedran Brnjetić
6,004 PointsVedran Brnjetić
6,004 Pointshappens in debugging, you find the first error you see and think it is solely responsible for all your problems. :D
Bularca Andrei
2,408 PointsBularca Andrei
2,408 PointsThank mate :D , I'll keep what you said in mind :)
Vedran Brnjetić
6,004 PointsVedran Brnjetić
6,004 PointsYeah, no problem. Have fun with the rest of the course.