Treehouse | Community | JOIN Queries

Join our Live Career-Building Workshop: Fast-Track Your Tech Career Without a Degree! ⭐ Register here!

🫡 Treehouse for Military offers discounts to Veterans, service members and their families!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

⭐Get support and network on our Discord server! ⭐

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Abdelhadi Boukdir
480 Points
My answer is correct but still showing error

Posted January 9, 2020 2:04pm by Abdelhadi Boukdir

Abdelhadi Boukdir
480 Points
1 Answer
maria mozglyakova
810 Points
hi. Why it is not right join (i must to save all records from Sale). Why i am wrong?

Posted December 15, 2019 7:00pm by maria mozglyakova

maria mozglyakova
810 Points
1 Answer
Eric Pan
13,398 Points
syntax error near "on" for join

Posted November 26, 2019 12:09am by Eric Pan

Eric Pan
13,398 Points
1 Answer
Jessica Schteiden
3,254 Points
Hey team, I tried this query out on Q3 but it didn't work. Can someone help me understand why it's breaking?

Posted November 17, 2019 9:24pm by Jessica Schteiden

Jessica Schteiden
3,254 Points
2 Answers
Shreemangal Sethi
Full Stack JavaScript Techdegree Student 15,552 Points
INNER JOIN 3 Table and Multiple Columns.

Posted September 30, 2019 10:40pm by Shreemangal Sethi

Shreemangal Sethi
Full Stack JavaScript Techdegree Student 15,552 Points
2 Answers
Jesse Dispoto
Front End Web Development Techdegree Graduate 14,538 Points
Join works in this example without specifying the columns to join

Posted August 8, 2019 12:07am by Jesse Dispoto

Jesse Dispoto
Front End Web Development Techdegree Graduate 14,538 Points
0 Answers
PLUS

Chris Gauthier
Courses Plus Student 6,434 Points
Interesting problem (to me, anyway). Im know I need 3 joins, but im not sure whats wrong with this. Can you help?

Posted June 10, 2019 5:02pm by Chris Gauthier

Chris Gauthier
Courses Plus Student 6,434 Points
2 Answers
Ankur Saxena
681 Points
Which is better in terms of Query execution and performance metrics?

Posted June 2, 2019 8:05am by Ankur Saxena

Ankur Saxena
681 Points
1 Answer
dfeem
4,660 Points
Looking for help on this challenge?

Posted February 19, 2019 4:38am by dfeem

dfeem
4,660 Points
1 Answer
Truman Smith
Full Stack JavaScript Techdegree Graduate 17,901 Points
Querying Relational Databases - challenge task 3

Posted February 5, 2019 5:10am by Truman Smith

Truman Smith
Full Stack JavaScript Techdegree Graduate 17,901 Points
2 Answers
Jordan Schall
5,269 Points
It will not accept my answer for this INNER JOIN of 3 tables.

Posted January 24, 2019 5:38pm by Jordan Schall

Jordan Schall
5,269 Points
2 Answers
Richard Külling
9,465 Points
How does this query not give the correct results?

Posted January 21, 2019 12:32am by Richard Külling

Richard Külling
9,465 Points
1 Answer
Mark Chesney
11,747 Points
SQL self join

Posted January 13, 2019 8:50pm by Mark Chesney

Mark Chesney
11,747 Points
2 Answers
Bennett Lappen
12,035 Points
How do I know which table to make 'Inner'?

Posted January 1, 2019 5:23pm by Bennett Lappen

Bennett Lappen
12,035 Points
1 Answer
George May
3,324 Points
Answers to Review and Practice

Posted December 31, 2018 10:46am by George May

George May
3,324 Points
3 Answers
David Corrales
4,698 Points
I asked an earlier question regarding the same challenge, but if possible, can you help me with this one?

Posted December 18, 2018 7:48am by David Corrales

David Corrales
4,698 Points
2 Answers
David Corrales
4,698 Points
This one seems so puzzling! I have already inserted 2 INNER JOINS, what else?!

Posted December 18, 2018 7:31am by David Corrales

David Corrales
4,698 Points
0 Answers
Sofia Eriksson
6,665 Points
Show all SaleDate, SaleAmount, and SalesRep First and Last name from Sale and SalesRep. Make sure that all Sales appear

Posted November 8, 2018 9:59pm by Sofia Eriksson

Sofia Eriksson
6,665 Points
1 Answer
Teacher Russell
16,873 Points
A little help with the approach of solving this challenge.

Posted October 19, 2018 12:41pm by Teacher Russell

Teacher Russell
16,873 Points
1 Answer
Sam Beattie
2,413 Points
Not sure what I have wrong. Can you help?

Posted October 15, 2018 4:48am by Sam Beattie

Sam Beattie
2,413 Points
2 Answers
Ali Dabbir Khan
1,076 Points
What's the mistake?

Posted October 2, 2018 8:01am by Ali Dabbir Khan

Ali Dabbir Khan
1,076 Points
1 Answer
rsa14
1,865 Points
My two inner joins won't work?

Posted September 21, 2018 9:14pm by rsa14

rsa14
1,865 Points
1 Answer
Sean McLeskey
2,033 Points
Why am I seeing an "ambiguous column name" error when I'm trying to join tables if the column name is spelled correctly?

Posted September 17, 2018 10:32pm by Sean McLeskey

Sean McLeskey
2,033 Points
2 Answers
PLUS

Ethan Martin
Courses Plus Student 1,883 Points
Identifying the Patrons with outstanding Book Loans and the Count of their Outstanding Books

Posted September 13, 2018 7:49pm by Ethan Martin

Ethan Martin
Courses Plus Student 1,883 Points
5 Answers
Alexander Davison
65,469 Points
Inner joins problem task 2

Posted August 15, 2018 3:22am by Alexander Davison

Alexander Davison
65,469 Points
1 Answer
Robbie Thomas
31,093 Points
Challenge Task 2 of 5

Posted August 14, 2018 2:58pm by Robbie Thomas

Robbie Thomas
31,093 Points
2 Answers
Robbie Thomas
31,093 Points
Querying Relational Databases

Posted August 13, 2018 4:20pm by Robbie Thomas

Robbie Thomas
31,093 Points
1 Answer
victorvillaplana
11,582 Points
Problem with the 1st task

Posted August 5, 2018 2:39pm by victorvillaplana

victorvillaplana
11,582 Points
2 Answers
Christopher Reynolds
2,817 Points
HELP me with this question.

Posted July 17, 2018 1:46pm by Christopher Reynolds

Christopher Reynolds
2,817 Points
2 Answers
Hanna Han
4,105 Points
Type of relationships among three different table in Tack #3

Posted June 27, 2018 6:21am by Hanna Han

Hanna Han
4,105 Points
1 Answer

Prev Page 2 of 3 Next

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.