Lucas Franzen wrote:

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

Hi Luc !

Wouldn't it be the same as the original query ? (Because IN is converted
to EXISTS internally)

I think you suggestion should work as the original query should work too.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br