UPDATE `pqrs-es-developmentdb`.survey_entity_mapping
INNER JOIN `pqrs-es-developmentdb`.survey ON (`pqrs-es-developmentdb`.survey_entity_mapping.surveyid = `pqrs-es-developmentdb`.survey.surveyid)
SET `pqrs-es-developmentdb`.survey_entity_mapping.year_id = `pqrs-es-developmentdb`.survey.survey_year_id