MySQL - Odd Query

[Adrian Schneider]

This is kind of a duplication of my other thread, just more generalized so it should be easier to answer.

Here is my current test-query:
[sql]SELECT team.id, team.manager, team.managerid, stats1.matchid, team.batsmanid1, stats1.runs AS batsman1runs, team.batsmanid2, stats2.runs AS batsman2runs
FROM fc_team team, fc_player_stats stats1, fc_player_stats stats2
WHERE team.gameid =7
AND team.batsmanid1 = stats1.playerid
AND team.batsmanid2 = stats2.playerid
ORDER BY manager ASC , stats1.matchid ASC[/sql]

Here are my results:


I did a very basic query afterwords to try and figure out why the extra results:
[sql]SELECT runs
FROM `fc_player_stats`
WHERE playerid =59
AND matchid =2[/sql]

The result was 8. (always the first of the many 'fake' results)

What causes these 'fake' results, and how can I filter through them. I'll also need to be able to do this on a similiar, more complex query (many more fake tables & where clauses).