pgsql update left join

update t_e_cj_stu_subject_score
set stuid = t2.userid
from public.tmp_student t2
where stuname = t2.name and examid = 'EX0000000116' ;