forse intendi la inner join?
select * from alunni inner join classi on (alunni.id_classe = classe.id_classe)