Hezll 博客

delete from db2011.hpmvp_info_baby where author in(select bs.author from (select b.author from db2011.hpmvp_info_mvp m,db2011.hpmvp_info_baby b where m.author=b.author) bs)

注意到in 后面采用的一个双层select写法了，原因就是因为in里边不能直接跟where

好了，问题解决了么？