update INDIVIDUAL_CANDIDACY_SERIES_GRADE
inner join
INDIVIDUAL_CANDIDACY
on INDIVIDUAL_CANDIDACY_SERIES_GRADE.OID_INDIVIDUAL_CANDIDACY = INDIVIDUAL_CANDIDACY.OID
set INDIVIDUAL_CANDIDACY_SERIES_GRADE.OID_DEGREE = INDIVIDUAL_CANDIDACY.OID_SELECTED_DEGREE;
