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

27 votes173 views6 answers
Set password mysql
SQL
0 vote165 views1 answer
Cannot pip install mysqlclient
SQL
0 vote153 views1 answer
Opensuse status MySQL
SQL
14 votes152 views4 answers
Remove record from table sql
SQL
0 vote179 views1 answer
Sql field equals multiple values
SQL
0 vote111 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
5 votes176 views1 answer
Oracle nls parameters
SQL
20 votes146 views1 answer
Get all table name in sql through php
SQL
10 votes215 views4 answers
Sql server pagination
SQL
0 vote154 views1 answer
Mariadb cast to int
SQL