Good,
I have 2 tables:
Cars:
- id;
- template;
- comb;
- price;
Car_img:
- id;
- id_fk; (foreign key of Cars)
- img;
I do this research:
SELECT DISTINCT carros.id, carros.modelo, carros_img.img, carros_desc.comb, carros_desc.preco
from carros, carros_desc, carros_img
where carros.id = carros_desc.id_fk
AND carros.id = carros_img.id_fk
order by carros.id ASC
And it appears:
Noid(idofthecarstable)appearssomeid'ssameasIdotoonlyappear1ofeachtype: