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
KRIS NIKOLAISEN53,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