SQL Update avec jointure de 2 tables

Exemple :

UPDATE R

SET R.Reponse = 3

FROM T_REPONSE AS R

INNER JOIN DP_SALARIE AS S ON R.NumSalarie = S.NUMERO_SALARIE

WHERE S.CATEGORIE = 3

AND R.CodeQuestion = 'CDD001'