Subject | Re: [firebird-support] SQL NOT IN |
---|---|
Author | Dmitry Yemanov |
Post date | 2005-11-23T05:50:50Z |
"Lucas Franzen" <luc@...> wrote:
Dmitry
>These queries are not equivalent regarding the NULL handling.
> > 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 )
Dmitry