Treehouse | Community | One to Many Relationships

🤑 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

Leigh Maher
21,830 Points
Is it realistic for this relationship to be one-to-many?

Posted March 11, 2022 11:27am by Leigh Maher

Leigh Maher
21,830 Points
2 Answers
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
Garrett Harriman
4,171 Points
Cannot Pass Challenge 2 of 6: SQL Set Operations Review (Fruit and Vegetables)

Posted September 28, 2021 11:50pm by Garrett Harriman

Garrett Harriman
4,171 Points
2 Answers
Özgür Yildirim
4,088 Points
What is wrong with this query?

Posted July 17, 2021 8:39pm by Özgür Yildirim

Özgür Yildirim
4,088 Points
1 Answer
Özgür Yildirim
4,088 Points
Task 4 of 4 is driving me mad. Obviously I do not get it

Posted July 17, 2021 8:33pm by Özgür Yildirim

Özgür Yildirim
4,088 Points
0 Answers
Özgür Yildirim
4,088 Points
My subquery doesn't return all CustomerIDs for people who identify as female (F), apparently. But why?

Posted July 17, 2021 7:47pm by Özgür Yildirim

Özgür Yildirim
4,088 Points
0 Answers
Özgür Yildirim
4,088 Points
Difference between UNION and UNION ALL for the second practice question?

Posted July 17, 2021 7:27pm by Özgür Yildirim

Özgür Yildirim
4,088 Points
0 Answers
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
Ola Ajayi
3,034 Points
I Have No Idea Where I Have Gone Wrong!

Posted May 6, 2021 9:28am by Ola Ajayi

Ola Ajayi
3,034 Points
1 Answer
Max Toth
3,777 Points
Subquery in the WHERE clause not detected?

Posted April 28, 2021 2:45pm by Max Toth

Max Toth
3,777 Points
1 Answer
Max Toth
3,777 Points
I've tried both approaches to a WHERE clause limiting names to '[a-k]%' (or NOT LIKE '[l-z]%' but neither does the trick

Posted April 23, 2021 8:24pm by Max Toth

Max Toth
3,777 Points
1 Answer
Zach Shlenker
2,277 Points
I need to exclude SQL query results that start with the letters L-Z.

Posted April 14, 2021 6:33pm by Zach Shlenker

Zach Shlenker
2,277 Points
2 Answers
PLUS

Jack Chaffin
Courses Plus Student 4,462 Points
How abstract should we get with normalization using foreign keys?

Posted April 13, 2021 5:43pm by Jack Chaffin

Jack Chaffin
Courses Plus Student 4,462 Points
2 Answers
Beckett Brees
3,390 Points
I am looking for a way to create a list of all fruits and vegetable from A - K; I have used BETWEEN and the > L, help.

Posted April 6, 2021 10:47am by Beckett Brees

Beckett Brees
3,390 Points
1 Answer
Terry Zhong
4,058 Points
Possible error in video - EXCEPT venn diagram min 1:09

Posted April 3, 2021 1:47pm by Terry Zhong

Terry Zhong
4,058 Points
1 Answer
Ariana Maksimović
2,797 Points
What is normalisation of database (in SQL) ?

Posted March 18, 2021 4:24pm by Ariana Maksimović

Ariana Maksimović
2,797 Points
1 Answer
jun cheng wong
17,021 Points
Check answer for question 2

Posted March 2, 2021 9:41am by jun cheng wong

jun cheng wong
17,021 Points
0 Answers
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
wc93
25,725 Points
Having problem selecting code because the test workspaces are too close to browser edge

Posted February 6, 2021 6:09pm by wc93

wc93
25,725 Points
0 Answers
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

Prev Page 2 of 8 Next

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