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 vote374 views2 answers
How to login to mysql as normal user in ubuntu
SQL
6 votes369 views1 answer
Phpmyadmin password root
SQL
2 votes424 views1 answer
Create delete procedure mysql
SQL
0 vote377 views1 answer
Sort by
SQL
36 votes383 views3 answers
Add column in mysq
SQL
0 vote332 views1 answer
Sql runnignsum
SQL
0 vote348 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
2 votes349 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote345 views1 answer
Check for directory in bash
SQL
15 votes388 views4 answers
Mysql export database command line
SQL