Select codpaese,p.DESCRIZIONE,SUM(arrivi) AS ARRIVI,SUM(partiti) AS PARTITI,SUM(presenze) AS PRESENZE from #tbltemp inner join tabpaesi as p on codpaese=p.codice group by codpaese"