select mk.MakeName, mk.ModelName from make as mk inner join Model as md on mk.MakeId = md.MakeId where mk.MakeName = "Chevy";
but it says No such Column ; Modelname
Steven Parker185,909 Points
The ModelName comes from the Model table, but you're using the table alias for the Make table to reference it.
So instead of "
mk.ModelName", use "