select fetchedhrs.forkliftcell

from fetchedhrs

where fetchedhrs.forkliftcell not in

(select forklift.forkliftcell from forklift)



Hi,



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
table.



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



Thanks,

Dion.



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