update A set (c1,c2) =(select B.c1,B.c2 from B where A.id=B.id and B.age>50) where exists(select 1 from B where A.id=B.id and B.age>50) 如果在set那报错你可以试试 update A set (c1,c2) =((select B.c1,B.c2 from B where A.id=B.id and B.age>50)) where exists(select 1 from B where A.id=B.id and B.age>50)