Databases Querying Relational Databases Joining Table Data with SQL JOIN Queries

My two inner joins won't work?

Keep getting an error, not sure what's I"m missing or if there's a typo/SYNTAX. Appreciate any help!

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

1 Answer

KRIS NIKOLAISEN
KRIS NIKOLAISEN
53,693 Points

You will want to join on keys with matching names. Try:

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