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?

Current Output

from...

select m.make, m.model, car.price, color.color, car.mileage, carlot.lotid
from makemodel as m, color, carlot, car;

Database Relationships



from Recent Questions - Stack Overflow https://ift.tt/3u0tm3Z
https://ift.tt/3dZHxB4

Comments

Popular posts from this blog

Today Walkin 14th-Sept

Hibernate Search - Elasticsearch with JSON manipulation

Spring Elasticsearch Operations