Forum PHP.pl

UPDATE
games_users
SET
games_users.users_id = 0
FROM
games_users
INNER JOIN
games_teams
ON
games_teams.id = games_users.games_teams_id
WHERE
games_teams.games_id = 1 AND
games_users.users_id = 2

UPDATE
games_users
SET
games_users.users_id = 0

#1064 - 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 'FROM games_users INNER JOIN games_teams ON games_teams.id = games_users.games_te' at line 5

                UPDATE
                    games_users
                INNER JOIN
                    games_teams
                ON
                    games_teams.id = games_users.games_teams_id
                SET
                    games_users.users_id = null
                WHERE
                    games_teams.games_id = :idGame AND
                    games_users.users_id = :idUser