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 vote143 views1 answer
Rermove categories woocommerce sql
SQL
0 vote130 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
1 vote143 views2 answers
Mysql remove first and last character from string
SQL
1 vote196 views1 answer
Python clean sql string
SQL
11 votes144 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote130 views1 answer
Mysql Error Code: 1005
SQL
0 vote148 views1 answer
Sql query to get column names and data types in sql server
SQL
1 vote162 views1 answer
Select not matching data with join table
SQL
0 vote136 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
16 votes131 views2 answers
Add column to all tables after first column mysql
SQL