Domanda di colloquio di Santander

In SQL how could you update a rows in one table by rows of the same table