codice:
select tab_a.nome_a,tab_b.nome_b
from tabella_c as tab_c
inner join tabella_a as tab_a on tab_c.id_a = tab_a.id_a
inner join tabella_b as tab_b on tab_c.id_b = tab_b.id_b