Treehouse | Community | JOIN Queries

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

Join our Live Career-Building Workshop: Launch Your Tech-Adjacent Career! ⭐ 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

Tracy Cano
6,656 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,656 Points
1 Answer
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
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
Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
Car data base query

Posted January 24, 2023 10:14pm by Gabriel Guerra

Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
2 Answers
Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
Querying Relational Database error

Posted January 21, 2023 2:03pm by Gabriel Guerra

Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
1 Answer
Katie Martens
1,962 Points
Inner Join

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

Katie Martens
1,962 Points
2 Answers
Omolade Akinwumi
1,068 Points
JOIN

Posted March 25, 2022 8:35am by Omolade Akinwumi

Omolade Akinwumi
1,068 Points
1 Answer
Omolade Akinwumi
1,068 Points
JOIN

Posted March 24, 2022 4:53pm by Omolade Akinwumi

Omolade Akinwumi
1,068 Points
0 Answers
Unsubscribed User
4,387 Points
In a car database there is a Sale table with columns, SaleID, CarID, CustomerID, LocationID, SalesRepID, SaleAmount and

Posted March 23, 2022 11:38am by Unsubscribed User

Unsubscribed User
4,387 Points
1 Answer
Deangelo Robinson
1,438 Points
I keep getting question 5 wrong so I can't move to the next step.

Posted March 3, 2022 8:25pm by Deangelo Robinson

Deangelo Robinson
1,438 Points
1 Answer
Deangelo Robinson
1,438 Points
Did anyone get the correct syntax for this?

Posted March 3, 2022 5:44pm by Deangelo Robinson

Deangelo Robinson
1,438 Points
1 Answer
Fred Russell
1,545 Points
Join returning seemingly too many (duplicate) rows.

Posted March 1, 2022 4:07pm by Fred Russell

Fred Russell
1,545 Points
1 Answer
yelena shakhanova
1,257 Points
any advise why this isn't accepting the code?

Posted February 18, 2022 6:13pm by yelena shakhanova

yelena shakhanova
1,257 Points
2 Answers
xczurymqdj
2,289 Points
can i please get some help with this challenge task 4 join queries?

Posted February 6, 2022 7:09pm by xczurymqdj

xczurymqdj
2,289 Points
0 Answers
xczurymqdj
2,289 Points
saying im missing the left key, Please someone help me?

Posted February 1, 2022 6:52pm by xczurymqdj

xczurymqdj
2,289 Points
1 Answer
Carlos Esquivel
5,867 Points
How to use SQL INNER JOIN to display Data from three different tables on a report.

Posted December 27, 2021 9:05pm by Carlos Esquivel

Carlos Esquivel
5,867 Points
1 Answer
Tatia Burdett
1,470 Points
LEFT OUTER JOIN, selecting from two tables, not resulting as expected.

Posted June 12, 2021 6:13pm by Tatia Burdett

Tatia Burdett
1,470 Points
1 Answer
jun cheng wong
17,021 Points
Task #3

Posted March 1, 2021 3:08pm by jun cheng wong

jun cheng wong
17,021 Points
1 Answer
Aquoinette Blair
3,539 Points
Subquery??

Posted January 11, 2021 2:38am by Aquoinette Blair

Aquoinette Blair
3,539 Points
2 Answers
Aquoinette Blair
3,539 Points
Ambiguous Error

Posted January 11, 2021 1:48am by Aquoinette Blair

Aquoinette Blair
3,539 Points
1 Answer
Aquoinette Blair
3,539 Points
Returning non joined columns with an inner join

Posted January 11, 2021 1:23am by Aquoinette Blair

Aquoinette Blair
3,539 Points
2 Answers
Dillon Cordel
1,774 Points
I'm getting the - SQL Error: Near "ON" Syntax Error - Message. I'm not sure why.

Posted January 5, 2021 4:20pm by Dillon Cordel

Dillon Cordel
1,774 Points
0 Answers
Roxanne Reyes
9,006 Points
Need help solving this challenge to join 3 tables.

Posted December 23, 2020 6:32pm by Roxanne Reyes

Roxanne Reyes
9,006 Points
1 Answer
Ra Bha
2,201 Points
Getting error: Bummer: SQL Error: no such column: Md.VIN . Okay, but why is this the case for a LEFT INNER JOIN?

Posted December 15, 2020 4:59pm by Ra Bha

Ra Bha
2,201 Points
0 Answers
Ra Bha
2,201 Points
If the tables are aliased to md and mk, how come the column names don't change when query is run?

Posted December 15, 2020 2:59pm by Ra Bha

Ra Bha
2,201 Points
1 Answer
Benjamin Hanley
3,410 Points
SQL Error: near "Car": syntax error

Posted July 2, 2020 2:34pm by Benjamin Hanley

Benjamin Hanley
3,410 Points
2 Answers
Tadjiev Codes
9,626 Points
In a car database there is a Sale table with columns, SaleID, CarID, CustomerID, LocationID, SalesRepID, SaleAmount and

Posted May 20, 2020 3:47am by Tadjiev Codes

Tadjiev Codes
9,626 Points
3 Answers
Tadjiev Codes
9,626 Points
In a car database there is a Model table with columns, ModelID, MakeID and ModelName and a Car table with columns, CarID

Posted May 19, 2020 11:33am by Tadjiev Codes

Tadjiev Codes
9,626 Points
3 Answers
Taylor Han
2,406 Points
Join Query with SQL

Posted April 23, 2020 7:50pm by Taylor Han

Taylor Han
2,406 Points
2 Answers
Zachary keller
3,178 Points
Outer Joins

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

Zachary keller
3,178 Points
1 Answer

Prev Page 1 of 3 Next

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