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

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
John Richter
2,351 Points
Not sure what the syntax error is

Posted November 20, 2020 11:25pm by John Richter

John Richter
2,351 Points
1 Answer
Ariadna Rodriguez
6,281 Points
I'm getting a syntax error and I don't know what I am missing.

Posted November 10, 2020 9:54am by Ariadna Rodriguez

Ariadna Rodriguez
6,281 Points
1 Answer
Joseph Fox
3,648 Points
I cannot figure out what I am doing wrong and this code runs properly in the playground before this quiz.

Posted November 8, 2020 9:04pm by Joseph Fox

Joseph Fox
3,648 Points
0 Answers
Georgina Wise
1,774 Points
Does a WHERE clause only appear at the end of a query or does it have to go both sides of the set function?

Posted November 5, 2020 3:56pm by Georgina Wise

Georgina Wise
1,774 Points
1 Answer
pashastegall
1,921 Points
Challenge 2 of 6 - A minor mistake somewhere!?

Posted October 18, 2020 6:46pm by pashastegall

pashastegall
1,921 Points
0 Answers
Lucio Bonforte
4,164 Points
I need help please! What am I doing wrong?

Posted October 8, 2020 8:53pm by Lucio Bonforte

Lucio Bonforte
4,164 Points
2 Answers
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
theteamtreehouse
3,472 Points
Link broken

Posted August 22, 2020 12:50am by theteamtreehouse

theteamtreehouse
3,472 Points
1 Answer
Betlem Ferrer
347 Points
Order by

Posted August 16, 2020 2:33pm by Betlem Ferrer

Betlem Ferrer
347 Points
0 Answers
sherelle smith
1,387 Points
Hey for challenge 1 of 6. Create a distinct result. I'm getting an error "you're missing UNION keyword"

Posted August 8, 2020 8:19pm by sherelle smith

sherelle smith
1,387 Points
2 Answers
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
Philip Porwisch
13,229 Points
Query not returning correct total

Posted June 27, 2020 6:20pm by Philip Porwisch

Philip Porwisch
13,229 Points
1 Answer
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
Melina Whitlock
2,977 Points
I am confused on how to use BETWEEN an LIKE in the same UNION query statement

Posted May 5, 2020 3:47pm by Melina Whitlock

Melina Whitlock
2,977 Points
2 Answers
Stacy Villibord
2,017 Points
Task 3 of 6

Posted April 30, 2020 7:48pm by Stacy Villibord

Stacy Villibord
2,017 Points
1 Answer
jeremyguida
8,211 Points
Task 1 of 6: SQL Set Operations

Posted April 28, 2020 5:41pm by jeremyguida

jeremyguida
8,211 Points
1 Answer
Taylor Han
2,406 Points
Subquery Task 4 (with alias?)

Posted April 26, 2020 3:04am by Taylor Han

Taylor Han
2,406 Points
2 Answers
Taylor Han
2,406 Points
In my yellow subquery, my yellow subquery (task 2)

Posted April 24, 2020 6:19pm by Taylor Han

Taylor Han
2,406 Points
1 Answer
Taylor Han
2,406 Points
Subquery with SQL (Task 1)

Posted April 23, 2020 11:39pm by Taylor Han

Taylor Han
2,406 Points
2 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
Anne-Marie Hofmann
1,776 Points
Update link pls!

Posted April 18, 2020 7:27am by Anne-Marie Hofmann

Anne-Marie Hofmann
1,776 Points
1 Answer
James Goedicke
2,205 Points
I have taken this quiz several times and have put in a query that matches the query discussed in the training,

Posted April 13, 2020 11:00pm by James Goedicke

James Goedicke
2,205 Points
4 Answers
fairest
Full Stack JavaScript Techdegree Graduate 19,303 Points
Is this a decent solution for challenge 2?

Posted March 27, 2020 2:46am by fairest

fairest
Full Stack JavaScript Techdegree Graduate 19,303 Points
2 Answers
George Waller
5,228 Points
Subquery using IN

Posted March 23, 2020 4:54pm by George Waller

George Waller
5,228 Points
1 Answer
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

Prev Page 3 of 8 Next

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