Subject | Re: Using FIRST in IF EXISTS(SELECT...) |
---|---|
Author | csswa |
Post date | 2002-04-12T16:26Z |
--- In ib-support@y..., Helen Borrie <helebor@t...> wrote:
here. :-) EXISTS testing is very useful and economical. Keep those
neat tips 'n tricks coming!
Thanks,
Andrew Ferguson
> EXISTS() isn't fetching a subset. In the select, it just tests therow it
> is looking at and either exits (because it found the match) ormoves 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!
Thanks,
Andrew Ferguson