[mysql] select strana

[baru]

non ho molta esperienza con mysql e mi sono imbattutto in qst problema :

io ho :

CREATE TABLE LEAGUEMATCHES (
 idLeagueMatches INT NOT NULL auto_increment,  index (idLeagueMatches),
 nomeLeagueMatches VARCHAR (50) default '',
 fk_League INT, index (fk_League),
 fk_Season INT, index (fk_Season),
 fk_TeamIn INT, index (fk_TeamIn),
 fk_TeamOut INT, index (fk_TeamOut),
 dateMatches DATE,
 status VARCHAR (50) default '',
 goalIn INT,
 goalOut INT,
 PRIMARY KEY (idLeagueMatches),
 FOREIGN KEY (fk_League) REFERENCES LEAGUE (idLeague),
 FOREIGN KEY (fk_Season) REFERENCES SEASON (idSeason),
 FOREIGN KEY (fk_TeamIn) REFERENCES TEAMS (idTeams),
 FOREIGN KEY (fk_TeamOut) REFERENCES TEAMS (idTeams)
) ENGINE=INNODB;

e

CREATE TABLE TEAMS (
 idTeams INT NOT NULL auto_increment,  index (idTeams),
 nomeTeams VARCHAR (50) default '',
 fk_Area INT,
 PRIMARY KEY (idTeams) ,
 FOREIGN KEY (fk_Area) REFERENCES AREA (idArea)
) ENGINE=INNODB;

il mio problema e fare una select che il risultato sia

nomeLeagueMatches , nomeTeams ( quello realtivo a fk_TeamsIn ) , nomeTeams ( quello realtivo a fk_TeamsOut )

... non riesco a risolvere qst problema ...


grazie a tutti in anticipo