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 SQL Calculating, Aggregating and Other Functions Grouping, Joining and Cleaning Up

Jacob Hafner
Jacob Hafner
9,864 Points
Posted by Jacob Hafner
Jacob Hafner
9,864 Points

JOINS are killing me

I've tried just about every order, specifying tables, switching where the ON/GROUP BY statements were. I just don't understand what I'm doing wrong and it feels like the join is what's killing me

Pablo Est
Pablo Est
473 Points

Provide more details so someone can help you

2 Answers

Jacob Hafner
Jacob Hafner
9,864 Points
Jacob Hafner
Jacob Hafner
9,864 Points

I actually found out that it wasn't the JOIN that was the issue. I wasn't selecting the right tables in my SELECT * FROM statement.

Pablo Est
Pablo Est
473 Points
Pablo Est
Pablo Est
473 Points

Cool you figured it out :)