日期:2014-05-17 浏览次数:20804 次
select * from table t where t.depart_nm='销售部' and t.status='售出' and t.sale_id not in (select sale_id from table t where t.depart_nm<>'销售部' and t.status='售出')