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

Source: techonthenet.com

Similar codes

0 vote153 views1 answer
Psql show db
SQL
0 vote143 views1 answer
Mysql drop multiple tables at once
SQL
0 vote159 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote135 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote138 views1 answer
Select other columns with distinct
SQL
2 votes163 views1 answer
Mysql cannot delete or update a parent row
SQL
7 votes136 views2 answers
Show size database mysql
SQL
0 vote158 views1 answer
Joomla execute raw sql
SQL
2 votes141 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
0 vote186 views1 answer
Oracle sqlp update amount / quantity
SQL