Mam problem z zapytaniem:

baaasmiley.gif
Kod
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


Jak zamiast:

Kod
UPDATE
games_users
SET
games_users.users_id = 0


Używam select *, wszystko działa tak jak powinno... Może ktoś widzi w tym jakiś błąd?

Kod
#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


Rozwiązanie:

Kod
                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