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

0 vote139 views1 answer
Sql table to store status
SQL
6 votes187 views1 answer
Oracle list primary key
SQL
0 vote195 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
0 vote186 views1 answer
Plpgsql raise notice
SQL
1 vote217 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
0 vote185 views1 answer
Sql shell psql cannot enter password
SQL
0 vote197 views1 answer
Sql server for loop
SQL
5 votes172 views2 answers
Sql conn
SQL
10 votes175 views4 answers
Primary key sql
SQL
0 vote173 views2 answers
Create fulltext index mysql
SQL