比如表Table
select * from Table t where
exists (select * from Table a where A='N' and t.id = a.id) and
exists (select * from Table b where B='N' and t.id = b.id) and
exists (select * from Table c where C='N' and t.id = c.id) ;
shit有那么复杂吗
select * from t where t.状态='N'