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