query select + join piu complessa

[Debiru]

Metodo facile:

select t1.nome as nome_txt, t2.nome as nome_comuni
from gamma as t0, gamma_txt as t1, prodotto_comuni as t2
where t0.id=t1.gamma_id_fk and t0.id=t2.gamma_id_fk

Metodo complesso:

select t1.nome as nome_txt, t2.nome as nome_comuni
from gamma as t0 inner join gamma_txt as t1
on t0.id=t1.gamma_id_fk
inner join prodotto_comuni as t2
on t0.id=t2.gamma_id_fk