UPDATE XXX T1 SET T1.AAA = (SELECT T2.AAA FROM YYY T2 WHERE T1.BBB = T2.BBB ) WHERE EXISTS (SELECT T2.AAA FROM YYY T2 WHERE T1.BBB = T2.BBB )