I have two tables EMPLOYEE & EMPLOYEE_ROLE. I'm trying to Update a column with a value from another column. I'm using SQL server join but i get an error -

[parse_syntax_error] Syntax error at or near 'FROM' line 3.

UPDATE C

SET C.title = B.title

FROM EMPLOYEE C

INNER JOIN EMPLOYEE_ROLE B

ON C.emp_id = B.emp_id

AND C.emp_name = B.emp_name