Subject SQL NOT IN
Author Dion
select fetchedhrs.forkliftcell

from fetchedhrs

where fetchedhrs.forkliftcell not in

(select forklift.forkliftcell from forklift)


I want all forklifts for which I have records in the FetchedHrs table but
no corresponding record in the Forklift table. I thought that the above sql
would work, but I get an empty resultant dataset. I am certain that there is
at least one record in the FetchedHrs table which is not in the Forklift

Is there an issue with this in FB v1.5.2.4731?



[Non-text portions of this message have been removed]