delete exists 

1 delete from TAB_JXGD_BPBJ a
2 where not EXISTS (select jxdid from tab_jxgd b where a.jxgdid=b.jxdid)

 

posted @ 2012-11-13 15:31  Seaurl  阅读(761)  评论(0)  编辑  收藏  举报