update 语法sql中的update语句

sql中的update语句

1.update A set jf=C.SM where exists (select id from (select id,sum(money) SM from B group by id) C where id=A.id); 2.update A set jf=C.SM where id in (select id from (select id,sum(money) SM from B group by id) C);