设定临时表f，并且参照临时表对表T_RWB的若干字段进行更新
WITH f AS( select RWBH,SKIP,SKWW,SKBH,‘进行‘ as RWZT from T_SKQDB as t where id in (select MAX(id) from T_SKQDB where RWZT=1 group by RWBH,RWZT,SJBH) ) update T_RWB SET SKIP=f.SKIP,SKWW=f.SKWW,SKBH=f.SKBH,RWZT=f.RWZT from T_RWB,f where T_RWB.RWBH=f.RWBH
同理，删除和更新共用：
WITH f AS( select RWBH,SKIP,SKWW,SKBH,‘进行‘ as RWZT from T_SKQDB as t where id in (select MAX(id) from T_SKQDB where RWZT=1 group by RWBH,RWZT,SJBH) ) delete from T_SKRWD where RWBH in (select RWBH from f)
原文：https://www.cnblogs.com/cdoneiX/p/12258570.html