Databases Querying Relational Databases Joining Table Data with SQL JOIN Queries

victorvillaplana
victorvillaplana
11,582 Points

Problem with the 1st task

I don't know how to solve this task. Could you help me? Thanks!!

I wrote this:

SELECT Model.ModelName, Car.VIN, Car.ModelYear, Car.StickerPrice FROM Car INNER JOIN Model ON Car.ModelID = Model.ModelID;

2 Answers

KRIS NIKOLAISEN
KRIS NIKOLAISEN
53,537 Points

You are also selecting Car.ModelYear which wasn't a requirement for the task. Remove that column and you should be good.

victorvillaplana
victorvillaplana
11,582 Points

Thank you, Kris! The query is ok now. V.