Thanks Svein,

is it possible to get the same result with a join?

Regards

Guido

Svein Erling Tysvaer wrote:

> That's simple Guido, just move TO2PCID and BLPCID into the where clause!
>
> select BLPCID,sum(BLGROSS_SALES),sum(BLRETURNS),sum(BLNETSALES),
> sum(BLDELIVERY_QUANTITY),sum(BLBACKLOG) from BACKLOG
> where BLCSGPID3=49 and
> not exists(select * from TURNOVER_PC_SUBGROUP where
> TO2CSGPID3=49 and TO2PCID = BLPCID)
> and BLPCID is not null
> group by BLPCID
>
> I added the 'and BLOPCID is not null' because I think the handling of
> NULL values may be slightly different between NOT IN and NOT EXISTS.
>
> Set
>
> Guido Klapperich wrote:
>> I have the following query
>>
>> select BLPCID,sum(BLGROSS_SALES),sum(BLRETURNS),sum(BLNETSALES),
>> sum(BLDELIVERY_QUANTITY),sum(BLBACKLOG) from BACKLOG
>> where BLCSGPID3=49 and
>> BLPCID not in (select TO2PCID from TURNOVER_PC_SUBGROUP where
>> TO2CSGPID3=49)
>> group by BLPCID
>>
>> I have read in the malinglist, that FB 2.0 don't use indexes with 'not
>> in' any more. Therefore I want to use 'not exists', but I'm not able to
>> convert the query. Can anybody help me?
>>
>> Regards
>>
>> Guido
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>