如果要删的是A表
DELETE FROM A WHERE A.ID IN (SELECT DISTINCT ID FROM B) AND A.DATE<=TO_DATE('20001231','yyyymmdd');如果要删B表你稍微修改一下就好了,不过这个删除过程效率不太高,效率高的还没想到,想到了再贴出来
DELETE FROM A WHERE A.ID IN (SELECT DISTINCT ID FROM B) AND A.DATE<=TO_DATE('20001231','yyyymmdd');如果要删B表你稍微修改一下就好了,不过这个删除过程效率不太高,效率高的还没想到,想到了再贴出来
delete a where a.date<=to_date('20001231','yyyymmdd') and exists
(select null from b where a.id=b.id);
明天再来结分