Databases Querying Relational Databases Joining Table Data with SQL JOIN Queries

Eric Pan
Eric Pan
13,398 Points

syntax error near "on" for join

select Model.ModelName, Car.VIN, Car.StickerPrice
from Model
inner join on Model.ModelID = Car.ModelID

I'm not quite sure where I went wrong with this syntax if anyone could give me some pointers thanks

1 Answer

KRIS NIKOLAISEN
KRIS NIKOLAISEN
53,693 Points

You need to specify a table to join

select Model.ModelName, Car.VIN, Car.StickerPrice from Model inner join Car on Model.ModelID = Car.ModelID