SELECT *
FROM concesionarios NATURAL JOIN distribution
GROUP BY cifc