Subject Re: [firebird-support] Problem with not in queries in Firebird 2.0 RC3
Author Dmitry Yemanov
"Graeme Edwards" <g.edwards@...> wrote:
> Is NOT EXISTS also an option to replace NOT IN in that it will use

Only for NOT NULL columns being a subject of NOT IN predicate. If the column
is nullable, then NOT EXISTS and NOT IN are not equivalent and expected to
return different results.