codice:
select tab1.valore+tab2.valore+tab3.valore as tot
from tabella1 as tab1
inner join tabella2 as tab2 on tab1.id = tab2.id
inner join tabella3 as tab3 on tab2.id = tab3.id
order by tot