SQL Join on Tables
Trying to join these tables to get desired column out (see picture 1) but after the third entry I am getting duplicate rows. So my question is would an inner join on the id values fix this?
from...
select m.make, m.model, car.price, color.color, car.mileage, carlot.lotid
from makemodel as m, color, carlot, car;
from Recent Questions - Stack Overflow https://ift.tt/3u0tm3Z
https://ift.tt/3dZHxB4
Comments
Post a Comment