Databases Querying Relational Databases Joining Table Data with SQL JOIN Queries

Not sure what I have wrong. Can you help?

I've tried this: SELECT Model.ModelName, Car.VIN, Car.StickerPrice FROM Model INNER JOIN Car ON Model.ModelID = Car.ModelID;

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

Brendan Whiting
Brendan Whiting
Front End Web Development Treehouse Moderator 84,579 Points

Which of the 5 challenge steps are you having trouble with? I ran that first SQL query and it worked for challenge 1

3rd challenge, where I've tried this: SELECT Sale.saleDate, Sale.saleAmount, SalesRep.firstName, SalesRep.lastName FROM Sale LEFT OUTER JOIN SalesRep ON Sale.salesRepId = SalesRep.salesRepId;

Yassin Chiguer
Yassin Chiguer
5,228 Points

Hi Sam, noticed your latest query is for challenge #5 not #3 which appears to be correct.

2 Answers

Yassin Chiguer
Yassin Chiguer
5,228 Points

For the 3rd challenge try this: select salesrep.firstname,salesrep.lastname,sale.saleamount from sale INNER JOIN salesrep ON sale.salesrepid=salesrep.salesrepid

This didn't work. It's still saying I'm missing the "IN" keyword. And yes, it's challenge 3 I'm referring to.

Yassin Chiguer
Yassin Chiguer
5,228 Points

Please can you share the complete question to the challenge you are encountering an issue?