Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases

Posted by Babatunde Obidare
Babatunde Obidare
Courses Plus Student 10,514 Points

Why this error? SQL Error: ambiguous column name: ModelName

Why this error? SQL Error: ambiguous column name: ModelName

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

2 Answers

Steven Parker
Steven Parker
231,140 Points
Steven Parker
Steven Parker
231,140 Points

:point_right: You have to identify the table when you join tables with similar column names.

Anytime you JOIN tables, if you select a column name that exists in more than one of the tables you must prefix it with the table name.

For example, if you joined tables named box and bow, and both had a column named color, to avoid ambiguity you would need to select either box.color or bow.color.

Babatunde Obidare
PLUS
Babatunde Obidare
Courses Plus Student 10,514 Points
Babatunde Obidare
Babatunde Obidare
Courses Plus Student 10,514 Points

Thanks! But it still did not work. Same error messge: SQL Error: ambiguous column name: ModelName

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