Subject | Re: [firebird-support] SQL NOT IN |
---|---|
Author | Lucas Franzen |
Post date | 2005-11-22T14:43:08Z |
Dion schrieb:
from fetchedhrs
WHERE NOT EXISTS
( SELECT * from forklift
WHERE FETCHEDHRS.FORKLIFTCELL = FORKLIFT.FORKLIFTCELL )
(sorry for any typo)
Luc.
> select fetchedhrs.forkliftcellselect fetchedhrs.forkliftcell
>
> from fetchedhrs
>
> where fetchedhrs.forkliftcell not in
>
> (select forklift.forkliftcell from forklift)
from fetchedhrs
WHERE NOT EXISTS
( SELECT * from forklift
WHERE FETCHEDHRS.FORKLIFTCELL = FORKLIFT.FORKLIFTCELL )
(sorry for any typo)
Luc.