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;
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;