delete from Readers where ID in ( select dz.ID from Readers dz left join XX04 bj on dz.BJBH=bj.BJBH left join JX01 zy on bj.ZYBH=zy.ZYBH where dz.SFZH in (select SFZH from Readers group by SFZH having count(SFZH) > 1) and zy.CCDM=‘4‘ )
原文：http://www.cnblogs.com/luoxiaozhao/p/6261822.html