select distinct t.demandNo
from t_aaa t, t_bbb o where 1=1 and t.Id=o.Id and t.demandNo not in (select t.demandNo from t_aaa t, t_bbbo where 1=1 and t.Id=o.Id and o.status=3 order by t.demandNo DESC)本文共 248 字，大约阅读时间需要 1 分钟。
select distinct t.demandNo
from t_aaa t, t_bbb o where 1=1 and t.Id=o.Id and t.demandNo not in (select t.demandNo from t_aaa t, t_bbbo where 1=1 and t.Id=o.Id and o.status=3 order by t.demandNo DESC)转载于:https://www.cnblogs.com/ityzw/p/5552200.html