-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Alexandre Benson
Smith
Sent: Tuesday, May 17, 2005 9:26 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Generic SQL question

Kjell Rilbe wrote:

>Perhaps I should add that what I want is to get all F records whose ID
>does not appear in table T (column T.ID).
>
>Kjell
>
>Kjell Rilbe wrote:
>
>
>>Just have to make sure I'm not going crazy. Please confirm that these
>>two SQL statements should return the same result:
>>
>>select count(*)
>>from F
>>where not exists (
>> select 1
>> from T
>> where T.ID = F.ID
>> )
>>
>>select count(*)
>>from F
>>where ID not in (
>> select ID
>> from T
>> )
>>
>>

I've found this behaviour on several occasions (Firebird 1.0.3).

Procedure with the second type of query ran well for year or two
and then suddenly - wrong results.

Regards
Bogdan