Subject Re: [firebird-support] SQL NOT IN
Author Dmitry Yemanov
"Lucas Franzen" <luc@...> wrote:
>
> > select fetchedhrs.forkliftcell
> > from fetchedhrs
> > where fetchedhrs.forkliftcell not in
> > (select forklift.forkliftcell from forklift)
>
> select fetchedhrs.forkliftcell
> from fetchedhrs
> WHERE NOT EXISTS
> ( SELECT * from forklift
> WHERE FETCHEDHRS.FORKLIFTCELL = FORKLIFT.FORKLIFTCELL )

These queries are not equivalent regarding the NULL handling.


Dmitry