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

12 votes305 views1 answer
Env var for setting password for root user mysql docker hub
SQL
0 vote303 views1 answer
How to get all values in a table mysql in c#
SQL
3 votes322 views2 answers
Sql paging query
SQL
0 vote337 views1 answer
Postgresql port 5432 not open
SQL
9 votes326 views4 answers
Oracle get table column names
SQL
3 votes462 views9 answers
Linq to sql converter online
SQL
0 vote397 views1 answer
Create view in sql server that contain multiple select statements
SQL
22 votes322 views3 answers
SQL CHEATSHEET
SQL
3 votes297 views1 answer
Oracle function
SQL
0 vote333 views1 answer
Apex for oracle 11g
SQL