Treehouse | Community | Querying Multiple Tables with JOIN

🤑 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

Samir Poonawala
29,951 Points
The codes not working =.=

Posted March 17, 2021 2:23pm by Samir Poonawala

Samir Poonawala
29,951 Points
1 Answer
Matt Nickolls
9,895 Points
Would using Join rather than left outer join to add the books table result in the same dataset?

Posted March 8, 2021 7:35pm by Matt Nickolls

Matt Nickolls
9,895 Points
1 Answer
Matt Nickolls
9,895 Points
Not sure about the distinction between Join and outer join

Posted January 14, 2021 11:58am by Matt Nickolls

Matt Nickolls
9,895 Points
2 Answers
Thomas Hewitt
17,691 Points
Why link the SQL basics course when it has zero information on the clearly more advanced SQL concepts used here????

Posted May 22, 2020 11:44am by Thomas Hewitt

Thomas Hewitt
17,691 Points
1 Answer
Riki Tiilikainen
4,042 Points
Can’t get the single_item_array to work

Posted April 30, 2020 6:19am by Riki Tiilikainen

Riki Tiilikainen
4,042 Points
2 Answers
Siraj Khan
3,451 Points
I couldn't get my head around anything the instructor saying over here.!

Posted December 31, 2018 10:26am by Siraj Khan

Siraj Khan
3,451 Points
2 Answers
Sean Flanagan
33,235 Points
Unable to retrieve results

Posted December 13, 2018 6:31pm by Sean Flanagan

Sean Flanagan
33,235 Points
4 Answers
Robbie Thomas
31,093 Points
Functions.php on video and workspace don't match.

Posted October 6, 2018 2:49pm by Robbie Thomas

Robbie Thomas
31,093 Points
1 Answer
jlampstack
23,932 Points
Would it be better to use LEFT OUTER JOIN to join Genres table?

Posted September 15, 2018 9:44pm by jlampstack

jlampstack
23,932 Points
0 Answers
Alex Forseth
8,017 Points
Is the database diagram what Alena is referencing when she says "that it is on the left"?

Posted January 18, 2018 11:27pm by Alex Forseth

Alex Forseth
8,017 Points
1 Answer
Andrew Dickens
18,352 Points
typo

Posted August 8, 2017 9:33am by Andrew Dickens

Andrew Dickens
18,352 Points
2 Answers
Artan Muzhaqi
7,983 Points
The code doesn't work. Unable to retrieve results SQLSTATE[HY000]: General error: 1 ambiguous column name: media_id

Posted July 16, 2017 2:29pm by Artan Muzhaqi

Artan Muzhaqi
7,983 Points
1 Answer
Mark Miller
45,831 Points
Why not fetchAll() when the query is specifically returning what we need?

Posted May 15, 2017 3:53pm by Mark Miller

Mark Miller
45,831 Points
2 Answers
jlampstack
23,932 Points
Where is $id pointing to???

Posted April 13, 2017 1:34pm by jlampstack

jlampstack
23,932 Points
3 Answers
Attila Balog
5,217 Points
I'm disappointed, bad code from the beginning of this course

Posted April 12, 2017 3:05pm by Attila Balog

Attila Balog
5,217 Points
3 Answers
Ronaldo Fialho
5,105 Points
unable to retrieve single data

Posted March 10, 2017 6:11pm by Ronaldo Fialho

Ronaldo Fialho
5,105 Points
1 Answer
Alex Flores
7,864 Points
How to post form data to database?

Posted February 24, 2017 2:37am by Alex Flores

Alex Flores
7,864 Points
3 Answers
Steve Berrill
20,016 Points
sql error when running this locally

Posted October 9, 2016 8:37am by Steve Berrill

Steve Berrill
20,016 Points
1 Answer
Chris Davis
16,280 Points
Dang!

Posted September 29, 2016 8:27pm by Chris Davis

Chris Davis
16,280 Points
0 Answers
SAHIL SANWAL
6,116 Points
getting unable to retreat

Posted July 12, 2016 12:35pm by SAHIL SANWAL

SAHIL SANWAL
6,116 Points
1 Answer
SAHIL SANWAL
6,116 Points
unable to retreat data if i use join

Posted July 12, 2016 12:33pm by SAHIL SANWAL

SAHIL SANWAL
6,116 Points
1 Answer
PLUS

janeporter
Courses Plus Student 23,471 Points
getting an error "Unable to retrieve data" when I include media_id in the query

Posted July 7, 2016 4:46pm by janeporter

janeporter
Courses Plus Student 23,471 Points
0 Answers
PLUS

dannyavery
Courses Plus Student 801 Points
Query not working with JOIN's. What am I missing?

Posted July 7, 2016 2:22pm by dannyavery

dannyavery
Courses Plus Student 801 Points
0 Answers
Igor Skoldin
6,779 Points
Code in the video won't work

Posted June 30, 2016 6:39am by Igor Skoldin

Igor Skoldin
6,779 Points
7 Answers
Joshua Esmero
10,571 Points
Getting "Integrity constraint violation: 1052" error from query

Posted June 28, 2016 11:49pm by Joshua Esmero

Joshua Esmero
10,571 Points
0 Answers
jinhwa yoo
10,042 Points
help me

Posted June 3, 2016 1:56am by jinhwa yoo

jinhwa yoo
10,042 Points
1 Answer
Daniel Goldberg
12,443 Points
single_item_array function not running properly. Problem with LEFT OUTER JOIN

Posted May 2, 2016 5:28pm by Daniel Goldberg

Daniel Goldberg
12,443 Points
3 Answers
Ian Rushton
15,789 Points
Workspaces not corresponding with video in Integrating 'PHP with Databases' Course - Querying Multiple Tables with JOIN

Posted April 26, 2016 10:22am by Ian Rushton

Ian Rushton
15,789 Points
7 Answers

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