SELECT t1.*, t2.nome AS comune_nome, t2.prov AS comune_provincia, t2.cap AS comune_cap FROM aziende AS t1, comuni AS t2 WHERE t1.id = '0' AND t1.id_comune = t2.id LIMIT 1