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

3 votes109 views2 answers
How to View column names of a table in SQL
SQL
0 vote121 views4 answers
What is unique key in sql
SQL
7 votes96 views1 answer
Safe mode mysql
SQL
0 vote123 views4 answers
Restart MySQL
SQL
0 vote124 views1 answer
Show the colums of table sql
SQL
0 vote76 views0 answer
How to connect to datbase in springboot
SQL
16 votes117 views3 answers
Delete row psql
SQL
1 vote125 views1 answer
Oracle activate job
SQL
1 vote128 views1 answer
What is in condition in sql
SQL
0 vote112 views1 answer
Create dump file mysql workbench
SQL