Sqlite update where exists

This article is tagged with: Sqlite update where exists and mysql

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');

This article is tagged with: Sqlite update where exists and mysql