Subqueries in UPDATE Statements

UPDATE itAppTranslationSkills
SET ASS_Specialisations = b.ASS_Specialisations
FROM itAppTranslationSkills AS a
INNER JOIN itAppSpecialisationSkillsExp AS b
    ON a.aid_pk = b.aid_pk  ;