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

3 votes173 views2 answers
Oracle sql truncate table
SQL
0 vote189 views1 answer
How to get specific salary in sql
SQL
1 vote191 views4 answers
Mysqldump 1 table only
SQL
2 votes207 views2 answers
Create temporary table in mysql
SQL
0 vote169 views1 answer
Sql get month and year from date
SQL
0 vote149 views1 answer
Raven ql select count
SQL
0 vote251 views1 answer
MySQL - How to find word with the most similar beginning
SQL
0 vote235 views1 answer
Mysql subtract month from timestamp
SQL
6 votes203 views3 answers
What is where in sql
SQL
0 vote282 views1 answer
Select milliseconds mysql
SQL