Update query with join(2 or more tables)

update b
set b.stock=a.openbal
from tbl_RMOpenBal a,tbl_Materialtypes b
where a.materialname=b.materialname and month(date)=month(getdate()) and year(date)=year(getdate())