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

8 votes342 views4 answers
How to calculate the age from date of birth in python
SQL
-1 vote341 views1 answer
Mysql order by on condition
SQL
0 vote358 views1 answer
Call object contructor and call methods of object
SQL
0 vote332 views1 answer
SqlFunction does not exist
SQL
0 vote332 views1 answer
Sql server bool select
SQL
3 votes320 views1 answer
How to remove characters from string in mysql
SQL
0 vote381 views1 answer
How to add mysql to path on termin after installation
SQL
0 vote371 views1 answer
Select year from dual oracle
SQL
0 vote352 views1 answer
Mysql query to select the highest value
SQL
0 vote337 views1 answer
Postgresql default value boolean
SQL