Treehouse | Community | JOIN Queries

🤑 Join the Treehouse affiliate program and earn 25% commission!

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

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

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

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

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
Jimmy Nguyen
8,895 Points
why doesnt this query work in bringing back distinct fruits and veggies starting with letters A-K?

Posted January 6, 2020 6:32pm by Jimmy Nguyen

Jimmy Nguyen
8,895 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
Erin DeSpain
6,763 Points
Impossible Results? "The subquery didn't return all CustomerIDs for people who identify as female (F)."

Posted December 11, 2019 7:34pm by Erin DeSpain

Erin DeSpain
6,763 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
Terrence Butler
1,201 Points
Stuck on problem

Posted October 24, 2019 6:09am by Terrence Butler

Terrence Butler
1,201 Points
1 Answer
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
Tommy Gebru
30,164 Points
Challenge Task 4 of 4 Bummer: SQL Error: near "SELECT": syntax error

Posted August 22, 2019 10:12pm by Tommy Gebru

Tommy Gebru
30,164 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
Remi Vledder
14,144 Points
Subquery 'loans challenge': Feedback on this solution

Posted July 29, 2019 12:40pm by Remi Vledder

Remi Vledder
14,144 Points
1 Answer
Peris Kwamboka
1,382 Points
Need help on returning fruits and vegetables with letters A to K - Task 2 challenge

Posted June 17, 2019 6:13am by Peris Kwamboka

Peris Kwamboka
1,382 Points
2 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
Skylar Gordon
7,943 Points
What does this return, if it doesn't return all sales to female customers?

Posted May 10, 2019 9:58pm by Skylar Gordon

Skylar Gordon
7,943 Points
2 Answers
PLUS

Kate Woodroffe
Courses Plus Student 6,685 Points
Stuck on task 4 of querying relational databases, sub queries assessment

Posted April 29, 2019 1:32pm by Kate Woodroffe

Kate Woodroffe
Courses Plus Student 6,685 Points
4 Answers
Ikechukwu Arum
5,337 Points
related to the subquery challenge using the "IN" Keyword

Posted April 4, 2019 6:40pm by Ikechukwu Arum

Ikechukwu Arum
5,337 Points
1 Answer
Brian Poirier
7,678 Points
select fruit and vegetables. what's wrong with this? SELECT * FROM fruit UNION SELECT * FROM vegetable

Posted March 22, 2019 2:25am by Brian Poirier

Brian Poirier
7,678 Points
1 Answer
Michael Nanni
7,358 Points
How do I filter query results between a range of starting letters?

Posted March 15, 2019 2:12am by Michael Nanni

Michael Nanni
7,358 Points
1 Answer
Hans Eisenman
1,315 Points
Having a little trouble with this derived table query. Error I'm getting is just "Bummer: try again!" :-\

Posted March 7, 2019 4:57pm by Hans Eisenman

Hans Eisenman
1,315 Points
1 Answer
Gia Hoang Nguyen
4,137 Points
How to reset the MakeID with the correct order ID?

Posted March 5, 2019 6:21am by Gia Hoang Nguyen

Gia Hoang Nguyen
4,137 Points
2 Answers
PLUS

Sharina Jones
Courses Plus Student 18,771 Points
Combining the results of subqueries

Posted February 20, 2019 10:10pm by Sharina Jones

Sharina Jones
Courses Plus Student 18,771 Points
1 Answer
PLUS

Sharina Jones
Courses Plus Student 18,771 Points
Query producing incorrect results

Posted February 20, 2019 7:55pm by Sharina Jones

Sharina Jones
Courses Plus Student 18,771 Points
2 Answers
dfeem
4,660 Points
Looking for help on this challenge?

Posted February 19, 2019 4:38am by dfeem

dfeem
4,660 Points
1 Answer
Dan K
10,689 Points
Column (Name) in Second Table is Gone?

Posted February 16, 2019 5:39am by Dan K

Dan K
10,689 Points
2 Answers
Hans Eisenman
1,315 Points
How do you build a Where clause that selects out all words which start with letters A-K?

Posted February 14, 2019 2:47pm by Hans Eisenman

Hans Eisenman
1,315 Points
4 Answers
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
Harris Handoko
3,932 Points
Please critique my code for the North South Book Loan practice problem

Posted February 3, 2019 4:41am by Harris Handoko

Harris Handoko
3,932 Points
4 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
Gia Hoang Nguyen
4,137 Points
Select * from Fruit Union Select * from Vegetable; I cant pass the challenge that asks to Create a distinct result"

Posted January 23, 2019 4:52am by Gia Hoang Nguyen

Gia Hoang Nguyen
4,137 Points
1 Answer

Prev Page 4 of 8 Next

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