Teacher Russell16,868 Points
A little help with the approach of solving this challenge.
I can look at answers posted and see my error, but I'm still very fuzzy here. It would have been very helpful to have a follow up explanation of these final exercises. Can someone give a little more in-depth explanation on how to begin looking at this one? Thanks in advance!:)
Brendan WhitingFront End Web Development Treehouse Moderator 84,578 Points
Here is my solution, and an explanation:
SELECT Model.ModelName, Car.VIN, Car.StickerPrice FROM Model INNER JOIN Car ON Model.ModelID = Car.ModelID;
- I'm selected all the columns that were requested by the challenge - ModelName, VIN, StickerPrice - with the explicit Column I'm selected them from. This isn't absolutely necessary but it helps make it clearer to understand.
- I just used INNER JOIN because in this case it doesn't seem to matter. Outer joins are for letting it know what to do if there are missing values.
Let me know if you have any questions.