摘要： SELECT * FROM "PUNISHER_ZGXXK" a WHERE (SELECT COUNT(1) FROM "PUNISHER_BMGL" b WHERE b.CODE=a.CODE and b.NAME =a.NAME)=0 这个sql语句查询a表的code和name没被b表都引用的 阅读全文