sqlite update where exists
UPDATE employees SET hire_date = (SELECT departments.start_date FROM departments WHERE departments.department_id = employees.department_id AND departments.department_name = 'HR') WHERE EXISTS (SELECT * FROM departments WHERE departments.department_id = employees.department_id AND departments.department_name ='HR');