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

Databases Querying Relational Databases Joining Table Data with SQL JOIN Queries

Posted by Deangelo Robinson
Deangelo Robinson
1,438 Points

Did anyone get the correct syntax for this?

This one is really tough and I can't proceed to the next portion of the course until I pass this question.

SELECT firstname, lastname, saleamount FROM sale sa INNER JOIN salesRep AS sr ON sa.SalesRepID = sr.SalesRepID;

1 Answer

Steven Parker
Steven Parker
231,275 Points
Steven Parker
Steven Parker
231,275 Points

I copied your code and pasted it into task 3 of the challenge and it passed. Try again?

Also, you can always move on in a course just by selecting the next step on the progress bar at the top of the page. The current step will be the one with a circle around it, just click on the next one. If you happen to be on the last step of a stage, you can click on the course title at the very top of the page and from there you can pick any step of any stage to jump to.