Update Query with join

// Without condition

UPDATE C INNER JOIN A ON C.Empid = A.Empid SET A.Empname =C.Empname

//With Condition

UPDATE C INNER JOIN A ON C.Empid = A.Empid SET A.Empname = C.Empname
WHERE (((A.Empname)="w"));