Subject Re: [firebird-support] SQL NOT IN
Author Lucas Franzen
Dion schrieb:
> 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 )


(sorry for any typo)

Luc.