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 @   Seaurl  阅读(765)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示