Subject Re: [firebird-support] SQL NOT IN
Author Dmitry Yemanov
"Alexandre Benson Smith" <iblist@...> wrote:
> Wouldn't it be the same as the original query ? (Because IN is converted
> to EXISTS internally)

Nope. IN and EXISTS always deliver the same result and internally executed
similarly. But this is untrue for NOT IN vs NOT EXISTS - they're different!
Also, they're differently optimized by v2.0.