Hi,
Its not possible. You can only update one table in update statement.
For the above scenario use sp like below
BEGIN TRANSACTION
UPDATE Table1
SET Table1.ColunmName = 'XXX'
WHERE Condition
UPDATE Table2
SET Table2.ColunmName = 'XXX'
WHERE Condition
COMMIT
Click
Here[
^] for more details about transaction.