UPDATE JOIN statement is used to update the one table with another table values by using JOIN condition.

UPDATE table1 SET table1_column = table2_column
FROM table1 INNER | LEFT JOIN table2
ON table1.column = table2.column
[WHERE condition]; 

Let us consider below table(s) as an example table(s) to frame the SQL query for getting the desired results.

Scenario – Update the values in table by using UPDATE JOIN.

Requirement1 – Update the dname on employee_details with dept_name from department_details by using INNER JOIN condition. The query was as follows –

UPDATE employee_details
SET  dname = department_details.dept_name
FROM employee_details INNER JOIN department_details ON
employee_details.dept_id = department_details.dept_id; 

BY executing above query, we can update the dname in employee_details table with dept_name of department_details table by using INNER JOIN condition. The table after update was as follows-

Scenario2 - Update the values in table by using UPDATE JOIN.

Let us consider the employee_details and department_details tables are as follows -

Requirement – Updating the manager_id on employee_details with dept_name on department_details by using LEFT JOIN condition. The query was as follows –

UPDATE employee_details SET dname = department_details.dept_name
FROM employee_details LEFT JOIN department_details ON
employee_details.dept_id = department_details.dept_id; 

BY executing above query, we can update the manager id in employee_details table with dept_name of department_details table by using LEFT JOIN condition. The table after update was as follows-