Can we later two tables at the same time?

Question

can we make changes in two different table with a single common column at the same time in a single query

Answer 1

You can modify only a single table with one UPDATE statement.
And there are some limitations how you can use joins inside UPDATE, but that completely depends on the database engine (different ways for each db)