删除:DELETE FROM TABLE1 WHERE EXISTS (SELECT 1 FROM TABLE2 WHERE TABLE1.ID=TABLE2.ID and TABLE2.DATE>’2011-01-01’) DELETE FROM A FORM TABLE1 A INNER JOIN TABLE2 B ON A.ID=B.ID WHERE B.DATE>’2011-01-01’更新:UPDATE A SET VOL1=C.VOL1,VOL2=C.VOL2,VOL3=C.VOL3 FROM TABLE1 A INNER JOIN TABLE2 C ON A.ID=C.ID WHERE C.NAME=’USA’ UPDATE A SET VAOL1=(SELECT VOL1 FROM TABLE2 C WHERE A.ID=C.ID AND C.NAME=’UAS’) FROM TABLE1 A另外,还可以使用CTE来帮助更新和删除。
DELETE FROM A FORM TABLE1 A INNER JOIN TABLE2 B ON A.ID=B.ID WHERE B.DATE>’2011-01-01’更新:UPDATE A SET VOL1=C.VOL1,VOL2=C.VOL2,VOL3=C.VOL3 FROM TABLE1 A INNER JOIN TABLE2 C ON A.ID=C.ID WHERE C.NAME=’USA’
UPDATE A SET VAOL1=(SELECT VOL1 FROM TABLE2 C WHERE A.ID=C.ID AND C.NAME=’UAS’) FROM TABLE1 A另外,还可以使用CTE来帮助更新和删除。