1 delete from TAB_JXGD_BPBJ a 2 where not EXISTS (select jxdid from tab_jxgd b where a.jxgdid=b.jxdid)
1 delete from TAB_JXGD_BPBJ a 2 where not EXISTS (select jxdid from tab_jxgd b where a.jxgdid=b.jxdid)
转载于:https://www.cnblogs.com/zhangwei595806165/archive/2012/11/13/2768116.html