prova cosi (nn l'ho testata):
codice:SELECT s1.nome, s2.nome FROM partite AS p INNER JOIN squadre AS s1 ON s1.id = p.squadraA INNER JOIN squadre AS s2 ON s2.id = p.squadraB WHERE p.id = 1
![]()
prova cosi (nn l'ho testata):
codice:SELECT s1.nome, s2.nome FROM partite AS p INNER JOIN squadre AS s1 ON s1.id = p.squadraA INNER JOIN squadre AS s2 ON s2.id = p.squadraB WHERE p.id = 1
![]()
think simple think ringo