codice:
select tab1.idtabella1,tab1.nome,tab1.cognome,tab2.colore
from tabella1 as tab1
inner join tabella2 as tab2
on tab1.idnumero = tab2.idnumero
order by tab2.idnumero asc