Hi Set,

> I'm just thinking that if using EXISTS when returning 100000+ records is a
> showstopper, then someone (e.g. Dmitry) ought to be made aware of it even
> though you got around it using JOIN. Anything peculiar beyond using exists?

Yes. At this point it was quite late and I was probably brain-dead, because
the JOIN statement gives me exactly the same result set ;-).

> I just asked IB_SQL to return me 226000 records using one exists - which it
> did without any problems.

Strange, but I don't care anymore, because it works with a joined query now.

Thanks,
Thomas