СУБД IBM DB2. Есть запрос, который говорят когда-то до меня работал:

select d.STRAH_NUM,d.FAM,d.IMYA,d.OTCHESTVO
from DECLARATION d, PAYMENT p
WHERE p.STRAH_NUM = d.STRAH_NUM and d.STRAH_NUM in (select p.strah_num
from PAYMENT p
where ((YEAR(p.date_enter)<=2013 and YEAR(p.date_poruch)=2013)
or (YEAR(p.date_poruch)<=2013 and YEAR(p.date_enter) is null))
)
and d.STRAH_NUM not in (select p.strah_num
from PAYMENT p
where YEAR(p.date_enter)=2014 and p.sum_woker>0
)
GROUP BY d.STRAH_NUM,d.FAM,d.IMYA,d.OTCHESTVO
ORDER by d.FAM

и сейчас запускаю - выдает ноль строк.
Переделал:

select d.STRAH_NUM,d.FAM,d.IMYA,d.OTCHESTVO
from DECLARATION d, (select distinct w.strah_num from PAYMENT w
where ((YEAR(w.date_enter)<=2013 and YEAR(w.date_poruch)<=2013) or
(YEAR(w.date_poruch)<=2013 and YEAR(w.date_enter) is null))
except
select distinct q.strah_num
from PAYMENT q
where YEAR(q.date_enter)=2014
) p
WHERE p.STRAH_NUM = d.STRAH_NUM
GROUP BY d.STRAH_NUM,d.FAM,d.IMYA,d.OTCHESTVO, D.NUM_RAION
ORDER by d.FAM

выдает нормально. В чем дело?

Добрый Э - Эх, спасибо. добавил как вы и говорили, и стало нормально!