update syntax error

[RexJacobus]

update tblmasteroverrun
set tblmasteroverrun.games_total = tg.total_games
from tbltotalgames tg
where tlbmasteroverrun.uid = tg.uid

I must be thick because I just can't see why this is giving me a syntax error. What am I missing? I've been staring at it for too long.

thx,
jim

 

[elsenorjose]

UPDATE tblmasteroverrun,tbltotalgames
SET tblmasteroverrun.games_total=tbltotalgames.total_games
WHERE tlbmasteroverrun.uid = tbltotalgames.uid

The preceding example shows an inner join that uses the comma operator, but multiple-table UPDATE statements can use any type of join allowed in SELECT statements, such as LEFT JOIN.

http://dev.mysql.com/doc/refman/5.0/en/update.html