[MYSQL+PHP]Non riesco a fare la query!!!Penso sia semplice..

[nicola75ss]

select t1.nome,count(t2.id_t1) as quanti
from t1 inner join t2
on t1.id = t2.id_t1
group by t2.id_t1