SQL update query using joins

Hi,
I am an Mysql programmer.
I need to update few table columns based on join condition of two SQL Server tables.
The query is as follows:
update c
set c.name = a.name,
c.category = a.class,
c.sub_category = a.schclass
from TableA as c inner join Table B as a on c.code = a.code

Just putting it for reference.

Thanx