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