ho provato con :

codice:
SELECT l.nomeLeagueMatches, l.fk_TeamIn, l.fk_TeamOut FROM leaguematches l, teams t1, teams t2 WHERE l.fk_TeamIn=t1.idTeams, l.fk_TeamOut=t2.idTeams ;
ma mi da ...

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' l.fk_TeamOut=t2.idTeams' at line 1