mysql update inner join

 

update pollexsurvey.pls_answer a inner join pollexsurvey.pls_respondent r
on a.respondent_uid=r.uid set a.respondent_id=r.respondent_id