[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

[baru]

ho provato con :

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

[piero.mac]

A prescindere da tutto il resto in cui evito di entrare nel merito...

nel WHERE le varie condizioni saranno in AND o altro, ma non separate da una virgola.