论坛 › Informix › sql请教，郁闷了。

qza 发表于 2009-10-10 15:00

unload to 4.unl
select policyno
from prpcitemkind
where startdate>"20090925"
and kindcode="BZ"
and policyno in (select policyno from prpcitemkind where kindcode="A")
and policyno in (select policyno from prpcitemkind where kindcode="B")
and policyno in (select policyno from prpcitemkind where kindcode="D1")
把exists换成policyno in就没问题了，郁闷

查看完整版本: sql请教，郁闷了。