如何在连接两个具有匹配ID的表时添加来自特定字段的列？

Question

我有2个表，汽车和经销商。

CARS: id, make, model, year, dealership_id 
DEALERSHIPS: id, name, address 

汽车有一个dealerhip_id属性，但不是经销商名称。如果cars.dealership_id和dealership.id匹配，如何在加入表格时添加经销商名称？

这是我到目前为止有：

SELECT cars.make, cars.model, cars.year 
FROM cars 
JOIN dealerships cars ON cars.dealership_id = dealership.id 

Answer 1

这个怎么样？

SELECT cars.make, cars.model, cars.year, dealerships.name 
FROM cars 
JOIN dealerships ON cars.dealership_id = dealerships.id