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 vote286 views2 answers
Sql unique
SQL
0 vote232 views1 answer
Mariadb errno 121
SQL
29 votes235 views5 answers
Mysql show table structure
SQL
0 vote234 views1 answer
Denormalise SQL command
SQL
0 vote210 views1 answer
Provera dupliranih konatakata
SQL
0 vote254 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote280 views1 answer
Pagination with row_number
SQL
0 vote229 views1 answer
Sql server select top 2 of each group
SQL
22 votes264 views3 answers
Year format in date mysql
SQL
1 vote254 views1 answer
Round one decimal place mysql
SQL