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

Posted by Mehiret Abdissa
Mehiret Abdissa
415 Points

What does it mean when it's says you are Missing the OUTTER KEY?

https://teamtreehouse.com/library/querying-relational-databases/joining-table-data-with-sql/join-queries

and I wrote the query :

select md.ModelName, c.Vin from Model as Md inner Join Car as c on Md.ModelId = c.ModelId

Thank you,

2 Answers

Mehiret Abdissa
Mehiret Abdissa
415 Points

Thank you so much,

It was misspelling error. Thank you again.

Dale Severude
seal-mask
.a{fill-rule:evenodd;}techdegree seal-36
Dale Severude
Full Stack JavaScript Techdegree Graduate 71,350 Points
Dale Severude
.a{fill-rule:evenodd;}techdegree seal-36
Dale Severude
Full Stack JavaScript Techdegree Graduate 71,350 Points

Hi Mehiret,

The challenge specifies to make sure models that aren’t in the Car table still show in the results. This means that an inner join will not work for this challenge. The error that you are getting is hinting to do a left outer join.

Mehiret Abdissa
Mehiret Abdissa
415 Points

Still error