Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
abduljamac2
5,528 PointsSQL Puzzle Help?
--
1 Answer
Steven Parker
229,732 PointsThis looks a bit more like "homework" than just a "puzzle". But the table structure is rather odd. Perhaps that's what question "b" is all about.
But for question "a" my suggestion is to consider joining the "car" table twice: once to look up the car, and again to look up the "parent".
abduljamac2
5,528 Pointsabduljamac2
5,528 PointsThis isnt homework ahaha I'm not in education but thank you for the help
Steven Parker
229,732 PointsSteven Parker
229,732 PointsI was going to give you a more specific answer but the question is no longer visible!