SQl select then use the results as a where on another table

SQl select then use the results as a where on another table

Hi i have very little sql writing experience i am trying to do a simple
select from one table then update another
so for example
select id from customer where name like 'Test'
then for each id it finds as there may be more than one
update customeractive set active=0 where id= "from the last table"