SQL UPDATE query with JOIN statement

Syntax of SQL UPDATE query 

UPDATE  tableName1(emp)
INNER JOIN tableName2(company)
ON emp.empId= company.empId
SET emp.empId= company.emp_name;

Leave a comment