Subject Re: Using FIRST in IF EXISTS(SELECT...)
Author csswa
--- In ib-support@y..., Helen Borrie <helebor@t...> wrote:
> EXISTS() isn't fetching a subset. In the select, it just tests the
row it
> is looking at and either exits (because it found the match) or
moves on and
> tests the next row.

OK. I'm not afraid to ask the illogical questions, as evidenced
here. :-) EXISTS testing is very useful and economical. Keep those
neat tips 'n tricks coming!

Andrew Ferguson