Need help with relation Database

Hello again everyone. I am trying to join 3 db’s together so i can echo out 1 string containing team name, player name and position.

Tables are set up as follows

team
team_id (Pk) auto ++
name

position
position_id (Pk) auto ++
position_name

players
player_id (Pk) auto ++
team_id
position_id
name

i tryed an sqlquery in phpMyAdmin but no luck

                            SELECT  * FROM team, positions, players
                            WHERE team.team_id = 1

[COLOR=Red] AND team.team_id = players.team_id(error on this line)[/COLOR]
AND players.position =players.position _id

Anyone have any idea if im doing this correctly?