How to change values ​​only in those fields that are in another related table?

Question

SQL

There are two tables related by key. You need to go through the first one and change the values ​​in those fields whose keys are selected in the second table according to some condition.
Example:
table 2: Next, I go over table 1 and change the fields for those rows that have an id field in the selection from table 2 above. Please tell me how this can be done?
select id, name from abc where name like '%van%'

Answer 1

UPDATE ...
WHERE id IN (SELECT id ...)