UPDATE XXXXXX S
SET (S.XXX,
S.CCC,
S.DDD,
S.AAA,
S.BBB) =
(SELECT F.XXX,
F.CCC,
F.AAA,
BBB
FROM XXXXXX F
LEFT JOIN XXXXX O
ON F.AAA = O.BBB
WHERE S.AAA = F.B
AND S.QQQ = F.WWW)
WHERE S.ZZZ = VVV;