Category "where-in"

Is there a way to search one table for certain values, and if successfully found, then update a different table?

Good afternoon all, This is my first time using SQL, so forgive me for being new. I have three different tables that I've created: CREATE TABLE employee (ID int