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

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
Arthur Dunn
2,094 Points
Can I get help with Question 4: Derived Tables?

Posted January 18, 2019 11:49pm by Arthur Dunn

Arthur Dunn
2,094 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
Alvand Hajizadeh
2,069 Points
Can't get question 2 for set questions.

Posted January 9, 2019 2:28am by Alvand Hajizadeh

Alvand Hajizadeh
2,069 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
PLUS

YA Abidakadr
Courses Plus Student 2,017 Points
help without using the keyword in

Posted December 26, 2018 5:50am by YA Abidakadr

YA Abidakadr
Courses Plus Student 2,017 Points
1 Answer
PLUS

YA Abidakadr
Courses Plus Student 2,017 Points
I need help please as soon as possible

Posted December 26, 2018 5:27am by YA Abidakadr

YA Abidakadr
Courses Plus Student 2,017 Points
1 Answer
David Corrales
4,698 Points
Oh my gosh this stuff is getting tough! Subqueries are challenging anyone know how to solve this?

Posted December 19, 2018 11:26pm by David Corrales

David Corrales
4,698 Points
4 Answers
David Corrales
4,698 Points
Something is missing to organize this, can someone help? I appreciate you!!

Posted December 19, 2018 9:51am by David Corrales

David Corrales
4,698 Points
1 Answer
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
PLUS

naveen rajavasireddy
Courses Plus Student 1,783 Points
Query works in SQL Playground but fails in quiz

Posted December 14, 2018 11:32pm by naveen rajavasireddy

naveen rajavasireddy
Courses Plus Student 1,783 Points
2 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
Stephen Robinson
7,461 Points
Why is my question being marked wrong when it is right?

Posted October 30, 2018 8:41pm by Stephen Robinson

Stephen Robinson
7,461 Points
2 Answers
Teacher Russell
16,873 Points
https://teamtreehouse.com/library/querying-relational-databases/subqueries/subqueries

Posted October 24, 2018 6:17pm by Teacher Russell

Teacher Russell
16,873 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'm getting wrong here. It says I'm missing the "IN keyword," but where would I put it?

Posted October 15, 2018 5:26am by Sam Beattie

Sam Beattie
2,413 Points
5 Answers
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
Fairooz Adams
2,704 Points
Keep getting an error.

Posted October 14, 2018 10:29pm by Fairooz Adams

Fairooz Adams
2,704 Points
2 Answers
Darran-Nehru Ram-Nehru
3,053 Points
Need help in the where condition for Names only starting between A through K.

Posted October 13, 2018 12:07pm by Darran-Nehru Ram-Nehru

Darran-Nehru Ram-Nehru
3,053 Points
1 Answer
Darran-Nehru Ram-Nehru
3,053 Points
Need help in the where condition for Names only starting between A through K.

Posted October 13, 2018 12:07pm by Darran-Nehru Ram-Nehru

Darran-Nehru Ram-Nehru
3,053 Points
0 Answers
Elsie Martinson
2,704 Points
Can't get past Task 2 of 4 - Querying Relational Databases

Posted October 2, 2018 1:13pm by Elsie Martinson

Elsie Martinson
2,704 Points
1 Answer
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
Sassafras Finley
13,168 Points
I have no idea why this isn't returning the right amount of rows. Please tell me what I've got wrong here.

Posted September 26, 2018 4:22pm by Sassafras Finley

Sassafras Finley
13,168 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
Robert Edwardes
15,777 Points
Using union all and not getting correct result

Posted September 15, 2018 10:28pm by Robert Edwardes

Robert Edwardes
15,777 Points
1 Answer
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
Gurdeep singh
1,522 Points
Need to know What's wrong with this code

Posted September 13, 2018 3:05pm by Gurdeep singh

Gurdeep singh
1,522 Points
2 Answers

Prev Page 5 of 8 Next

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