Multiple table updates (Was: Does Update allow for aliases)

[Chris White]

Reading the noted previous thread, I was curious as to updating multiple 
tables.  I read the MySQL docs, which mentions that you can do it:

Multiple-table syntax:
UPDATE [LOW_PRIORITY] [IGNORE] /|table_references|/
   SET /|col_name1|/=/|expr1|/ [, /|col_name2|/=/|expr2|/ ...]
   [WHERE /|where_condition|/]


However, I didn't see any sort of example for achieving this (that 
wasn't somewhat complicated). Does anyone have a base example 
(preferably with table structure) that can show how this works?