> Season Greetings everyone!
>
> Can anybody give me somes notes on uses of "IN" and "EXIST". How are
> they being use? Which is much preferred?
>
> Thanks

to quote Celko
"An EXISTS predicate can use indexes to find.. or fail, whereas the IN
predicate ofen has to build the results of the subquery in a working table"

not sure exactly how FB is optimised in this regard
Alan