Treehouse | Community | Inner Joins

🤑 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

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
Angyal István
11,259 Points
how to limit results in a string range [e.g. show all names with starting letter from 'a' to 'k']?

Posted February 13, 2020 7:09pm by Angyal István

Angyal István
11,259 Points
2 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.