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

Tracy Cano
6,645 Points
Can someone help me understand how to answer this question about outer joins?

Posted October 15, 2023 8:54pm by Tracy Cano

Tracy Cano
6,645 Points
1 Answer
Alex Hort-Francis
12,924 Points
My solution

Posted October 15, 2023 4:40pm by Alex Hort-Francis

Alex Hort-Francis
12,924 Points
0 Answers
Alex Hort-Francis
12,924 Points
On the `DISTINCT` keyword per column in the instructor's example query

Posted October 15, 2023 3:42pm by Alex Hort-Francis

Alex Hort-Francis
12,924 Points
1 Answer
Rojina Pradhan
2,681 Points
Find all the matches in the results table where "Hessle" was playing away as the away team and if they played on or afte

Posted October 3, 2023 2:19pm by Rojina Pradhan

Rojina Pradhan
2,681 Points
2 Answers
Rojina Pradhan
2,681 Points
We're back using the e-commerce database. I only have 10.99 left in my bank account. Write a query that will return all

Posted October 2, 2023 6:05pm by Rojina Pradhan

Rojina Pradhan
2,681 Points
3 Answers
Nataliia Kalinicheva
5,433 Points
I selected 6 columns from 6 and I've got "You didn't select all columns". What should I do?

Posted September 27, 2023 7:54pm by Nataliia Kalinicheva

Nataliia Kalinicheva
5,433 Points
1 Answer
Tremayne Moncrief
2,324 Points
I need help with this question

Posted September 14, 2023 3:14am by Tremayne Moncrief

Tremayne Moncrief
2,324 Points
0 Answers
Rosina Marchan
3,011 Points
There are two tables Fruit and Vegetable table. The Fruit table has a FruitID and a Name column and the Vegetable table

Posted September 7, 2023 6:58pm by Rosina Marchan

Rosina Marchan
3,011 Points
1 Answer
Rosina Marchan
3,011 Points
What am I missing?

Posted September 7, 2023 6:53pm by Rosina Marchan

Rosina Marchan
3,011 Points
1 Answer
Rosina Marchan
3,011 Points
Back in the teachers notes I included a reference to how other databases LIMIT results.

Posted September 2, 2023 2:12pm by Rosina Marchan

Rosina Marchan
3,011 Points
1 Answer
Jason Chalangary
11,695 Points
Bug in the Javascript

Posted August 16, 2023 12:39pm by Jason Chalangary

Jason Chalangary
11,695 Points
1 Answer
Jason Chalangary
11,695 Points
What is wrong with my code?

Posted August 15, 2023 1:21pm by Jason Chalangary

Jason Chalangary
11,695 Points
2 Answers
Juan Moyar
2,871 Points
Result form Task 1

Posted August 4, 2023 3:42pm by Juan Moyar

Juan Moyar
2,871 Points
2 Answers
Uhunoma Osula
6,414 Points
THIS WORKED TOO

Posted July 17, 2023 11:37am by Uhunoma Osula

Uhunoma Osula
6,414 Points
1 Answer
ashwathh
3,129 Points
how to format date in mm/yyyy format in SQL?

Posted June 27, 2023 12:10am by ashwathh

ashwathh
3,129 Points
1 Answer
Jace Vanwagoner
6,767 Points
How can I save the SQL Playground practice's to be able to add them to a portfolio???

Posted May 24, 2023 3:14pm by Jace Vanwagoner

Jace Vanwagoner
6,767 Points
1 Answer
Tyric Foreman
1,398 Points
when youre double checking your work and youre still stuck on a task, how do you get the answer to move along ?

Posted May 11, 2023 10:51am by Tyric Foreman

Tyric Foreman
1,398 Points
- Databases
1 Answer
Sarah E
1,961 Points
Modifying Data with SQL Challenge question

Posted May 10, 2023 2:54pm by Sarah E

Sarah E
1,961 Points
3 Answers
PLUS

zaal rottunda
Courses Plus Student 2,434 Points
Use a subquery along with IN to list all the Model Names with a Sticker Price greater than $30000

Posted May 7, 2023 11:56pm by zaal rottunda

zaal rottunda
Courses Plus Student 2,434 Points
4 Answers
Codi Hasbrouck
41 Points
Date datatype

Posted May 6, 2023 11:26am by Codi Hasbrouck

Codi Hasbrouck
41 Points
- Databases
0 Answers
PLUS

zaal rottunda
Courses Plus Student 2,434 Points
SQL Error: no such column: VIN

Posted May 3, 2023 8:46pm by zaal rottunda

zaal rottunda
Courses Plus Student 2,434 Points
1 Answer
Daiana Cherhynets
1,354 Points
SELECT ||(first_name, ' ', last_name, ' <', email, '>') AS to_field FROM patrons

Posted April 30, 2023 10:44pm by Daiana Cherhynets

Daiana Cherhynets
1,354 Points
1 Answer
Alexander Tomashevskiy
8,326 Points
Hello, Please help me, what wrong with my command?

Posted April 29, 2023 1:59pm by Alexander Tomashevskiy

Alexander Tomashevskiy
8,326 Points
1 Answer
Alexander Tomashevskiy
8,326 Points
I don't understand where is the mistake? Bummer: Expecting results like 'L Chalkley' not 'L Chalkley'.

Posted April 26, 2023 12:15pm by Alexander Tomashevskiy

Alexander Tomashevskiy
8,326 Points
1 Answer
PLUS

zaal rottunda
Courses Plus Student 2,434 Points
IN a library database....

Posted April 24, 2023 4:23pm by zaal rottunda

zaal rottunda
Courses Plus Student 2,434 Points
4 Answers
Alyssa Daniel
1,944 Points
I don't understand

Posted April 20, 2023 7:43pm by Alyssa Daniel

Alyssa Daniel
1,944 Points
1 Answer
PLUS

zaal rottunda
Courses Plus Student 2,434 Points
What does this error mean: Bummer: Was expecting 7 entries in the phone_book table. There's only 6.

Posted April 17, 2023 7:09pm by zaal rottunda

zaal rottunda
Courses Plus Student 2,434 Points
7 Answers
Anakin Bjelland
7,176 Points
I need some help with this union challenge

Posted March 30, 2023 9:40pm by Anakin Bjelland

Anakin Bjelland
7,176 Points
1 Answer
Eric Agbayani
Full Stack JavaScript Techdegree Graduate 15,011 Points
Adding a new product, but my command is not working.

Posted March 24, 2023 7:43pm by Eric Agbayani

Eric Agbayani
Full Stack JavaScript Techdegree Graduate 15,011 Points
1 Answer
Wufei Hong
1,393 Points
bummer reason

Posted March 24, 2023 6:08am by Wufei Hong

Wufei Hong
1,393 Points
1 Answer

Prev Page 2 of 388 Next

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