Treehouse | Community | JOIN Queries

You found it first ⚡ 50% off any plan for 6 months, exclusive to new subscribers for a limited time only.

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

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Zachary keller
3,178 Points
Outer Joins

Posted March 13, 2020 8:57pm by Zachary keller

Zachary keller
3,178 Points
1 Answer
Claire Brehm
9,098 Points
Task 1 challenge help

Posted February 28, 2020 12:57am by Claire Brehm

Claire Brehm
9,098 Points
2 Answers
Claire Brehm
9,098 Points
Having trouble with question 3

Posted February 28, 2020 12:03am by Claire Brehm

Claire Brehm
9,098 Points
3 Answers
Angyal István
11,324 Points
how to limit results in a string range [e.g. show all names with starting letter from 'a' to 'k']?

Posted February 13, 2020 7:09pm by Angyal István

Angyal István
11,324 Points
2 Answers
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

Prev Page 4 of 9 Next

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