SQL-problem -> INNER JOIN

[Anon]

I have had major problems with this one:

$listg = "SELECT player.PlayerID, player.Firstname, player.Lastname, team.TeamID, team.Team, stats.PlayerID, stats.TeamID FROM player INNER JOIN stats INNER JOIN team ON stats.TeamID=team.TeamID ON player.PlayerID=stats.PlayerID WHERE team.TeamID LIKE '$tID' AND stats.EndDate='2002' AND player.Pos='G' ORDER BY player.Lastname asc";

This query basically looked this way when I used it with ASP, now the site is done with php, and the query won't work anymore.

Could anyone find an error?

thanks a bunch!

[Anon]

The ON clause should be immediately after the second table in the join. I.e.

listg = "SELECT player.PlayerID, player.Firstname, player.Lastname, team.TeamID, team.Team, stats.PlayerID, stats.TeamID FROM player INNER JOIN stats ON stats.TeamID=team.TeamID INNER JOIN team ON player.PlayerID=stats.PlayerID WHERE team.TeamID LIKE '$tID' AND stats.EndDate='2002' AND player.Pos='G' ORDER BY player.Lastname asc";