update from data select in sql server

update From data select

example :

update tm_access_det  set  AJD_Emplcode=20033
from  tm_access_det
inner join tm_access_hdr a on AJD_HeaderID=AJH_ID
inner join tbmst_section on ajh_sectioncode=sec_sectioncode
inner join tbmst_employee  on em_emplcode=AJD_Emplcode
where  AJD_Emplcode=10043