Treehouse | Community | JOIN Queries

💥 2026 New Year's Sale 💥 Take 50% off your first 6 months! (new subscribers only, renews at regular price).

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Katie Martens
1,962 Points
Inner Join

Posted June 28, 2022 8:41pm by Katie Martens

Katie Martens
1,962 Points
2 Answers
Andy England
6,820 Points
ERROR? Bummer: Expecting results like 'L Chalkley' not 'L Chalkley'.

Posted June 2, 2022 4:17pm by Andy England

Andy England
6,820 Points
- Databases
2 Answers
K. Brice Perez
15,095 Points
how to add a new product to a table?

Posted March 24, 2022 12:32am by K. Brice Perez

K. Brice Perez
15,095 Points
1 Answer
Unsubscribed User
4,387 Points
We're in a movie database. There's a reviews table with the columns of id, movie_id, username, rev

Posted March 22, 2022 3:29pm by Unsubscribed User

Unsubscribed User
4,387 Points
1 Answer
Unsubscribed User
4,511 Points
Why doesn't this work?

Posted March 21, 2022 7:11pm by Unsubscribed User

Unsubscribed User
4,511 Points
2 Answers
xczurymqdj
2,289 Points
Where can I practice everything that i've learned in SQL

Posted March 3, 2022 4:08pm by xczurymqdj

xczurymqdj
2,289 Points
- Databases
1 Answer
Jason Kirkpatrick
2,117 Points
Can't seem to get this, though I think I'm counting the numbers of books in each genre instead of each genre. How?

Posted February 18, 2022 6:04pm by Jason Kirkpatrick

Jason Kirkpatrick
2,117 Points
1 Answer
Nandan Pandey
5,210 Points
In an ecommerce database we have a products table with the columns id, name, category, description, price and stock_coun

Posted December 14, 2021 5:24pm by Nandan Pandey

Nandan Pandey
5,210 Points
1 Answer
Alejandro Aburto Salazar
7,733 Points
Adding foreign key not working

Posted December 10, 2021 8:22am by Alejandro Aburto Salazar

Alejandro Aburto Salazar
7,733 Points
2 Answers
xczurymqdj
2,289 Points
In need of some help again, My code is not working right. please help me.

Posted November 16, 2021 8:21pm by xczurymqdj

xczurymqdj
2,289 Points
6 Answers
Anne Olaribigbe
154 Points
My code is not working Here is the code

Posted November 7, 2021 7:43pm by Anne Olaribigbe

Anne Olaribigbe
154 Points
1 Answer
xczurymqdj
2,289 Points
im not sure what im doing wrong with my code, can someone please tell me what im doing wrong

Posted November 1, 2021 6:40pm by xczurymqdj

xczurymqdj
2,289 Points
4 Answers
Michelle Ward
732 Points
I am stuck on task 1 of 2 in the concatenating lesson.

Posted October 27, 2021 5:36am by Michelle Ward

Michelle Ward
732 Points
1 Answer
Van Nguyen
3,533 Points
Where can I put the angle bracket around the email?

Posted November 20, 2020 4:27pm by Van Nguyen

Van Nguyen
3,533 Points
1 Answer
Leslie Whitford
714 Points
What am I doing wrong in my command?

Posted September 10, 2020 6:50pm by Leslie Whitford

Leslie Whitford
714 Points
1 Answer
theteamtreehouse
3,472 Points
When and where is this mentioned, what is the answer and why?

Posted August 22, 2020 2:50pm by theteamtreehouse

theteamtreehouse
3,472 Points
1 Answer
Michael Trilford
182 Points
What is the best course to learn about data on the web?

Posted May 30, 2020 2:35am by Michael Trilford

Michael Trilford
182 Points
- Databases
1 Answer
Samantha York
703 Points
I cannot figure out the solution to Challenge Task 1 of 2 under Reporting with SQL: Adding Text Columns Together

Posted April 23, 2020 11:10pm by Samantha York

Samantha York
703 Points
2 Answers
lucas caldeira
1,592 Points
Is there a better way to do this ? this doesn't feel right !

Posted February 26, 2019 5:08pm by lucas caldeira

lucas caldeira
1,592 Points
- Databases
1 Answer
Thomas Wilson
18,741 Points
I keep getting the wrong sum but I don't know what I'm doing wrong.

Posted January 17, 2019 2:53pm by Thomas Wilson

Thomas Wilson
18,741 Points
1 Answer
Ben Brown
799 Points
I am typing in results for the Table, but it is saying that I am not selecting from the results table

Posted December 13, 2018 3:58pm by Ben Brown

Ben Brown
799 Points
1 Answer
Jamie Sims
4,317 Points
I'm not sure how I should treat my SQL Statement.

Posted October 9, 2018 6:03pm by Jamie Sims

Jamie Sims
4,317 Points
1 Answer
Progress Masocha
4,347 Points
Not sure what to do here

Posted October 1, 2018 12:36pm by Progress Masocha

Progress Masocha
4,347 Points
1 Answer
Lanie Haynes
2,691 Points
I am not sure what is off about my syntax here

Posted August 17, 2018 7:23pm by Lanie Haynes

Lanie Haynes
2,691 Points
1 Answer
Jason Tabaczynski
3,177 Points
Can't create table with the CREATE TABLE command

Posted May 12, 2018 6:56pm by Jason Tabaczynski

Jason Tabaczynski
3,177 Points
1 Answer
Brian Patterson
19,588 Points
Cant create database with Sequel Pro

Posted February 15, 2018 6:22pm by Brian Patterson

Brian Patterson
19,588 Points
- Databases
1 Answer
Abdullah Jassim
4,551 Points
Once the two functions: Fifth and Seventh are created, instead of using inner join, why cant we use Union ALL?

Posted February 7, 2018 7:03pm by Abdullah Jassim

Abdullah Jassim
4,551 Points
1 Answer
Zoltan Voros
2,529 Points
Substr() error?

Posted January 27, 2018 11:03pm by Zoltan Voros

Zoltan Voros
2,529 Points
- Databases
1 Answer
MOD

Iain Simmons
Treehouse Moderator 32,305 Points
BETWEEN is inclusive

Posted January 27, 2016 1:58am by Iain Simmons

Iain Simmons
Treehouse Moderator 32,305 Points
2 Answers

Prev Page 214 of 389 Next

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