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

Databases

Abdullah Jassim
Abdullah Jassim
4,551 Points
Posted by Abdullah Jassim
Abdullah Jassim
4,551 Points

Hi I am not sure what am I doing wrong. Please advise.

SELECT Make.MakeName, Model.ModelName, Car.VIN, Car.ModelYear, Car.StickerPrice FROM Make INNER JOIN Model ON Make.MakeID = Model.MakeID INNER JOIN Car ON Model.ModelID = Car.ModelID;

Si Cheng Zhou
Si Cheng Zhou
3,944 Points
Si Cheng Zhou
Si Cheng Zhou
3,944 Points

Try joining Model on Car. We need a right outer join for the desired output if joining Car on Model

1 Answer

vincent batteast
vincent batteast
51,094 Points
vincent batteast
vincent batteast
51,094 Points

you code look good but I'm not sure what error you are getting or what problem you are trying to solve. but here is some information on join and if you can give more information I'm sure I can help

https://www.w3resource.com/sql/joins/perform-an-inner-join.php