Una query per tabelle unite

[nicola75ss]

select cd.*
from cd
inner join cd_musicisti_autori as cma
on cd.id = cma.id_cd
inner join musicisti m
on cma.id_musicisti = m.id
where m.nome = 'mario' and m.cognome = 'rossi'