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

1 vote214 views1 answer
Rails run native ssql query
SQL
0 vote220 views1 answer
Firebase sql
SQL
0 vote207 views1 answer
How to to get current date in sql
SQL
0 vote216 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
2 votes216 views1 answer
Mysql increment value by 1 in update
SQL
2 votes243 views1 answer
Oracle find constraints referencing a table
SQL
0 vote216 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
10 votes200 views1 answer
Dba_dependencies
SQL
0 vote199 views1 answer
Oracle last connection
SQL
3 votes207 views3 answers
Create a view postgres
SQL