How to update multiple tables at the same time?

You can’t update fields from multiple tables on a single update query. There error you are getting is because this is not permitted:

update a, b, c

Since you can only update one table per update command.