Subject | Re: [firebird-support] More indexed reads with FB 2.0 |
---|---|
Author | Guido Klapperich |
Post date | 2006-08-11T19:59:06Z |
BTW, I have tried to convert the query into a left like this
select BLPCID,sum(BLGROSS_SALES),sum(BLRETURNS),sum(BLNETSALES),
sum(BLDELIVERY_QUANTITY),sum(BLBACKLOG)
from BACKLOG left join TURNOVER_PC_CS on BLPCID=TO6PCID
join CUSTOMERS on TO6CSID=CSID and CSUSID1=56 and CSGPID3=65
where TO6PCID is null
group by BLPCID
but I don't get the right results. Any idea, where the error could be?
Regards
Guido
select BLPCID,sum(BLGROSS_SALES),sum(BLRETURNS),sum(BLNETSALES),
sum(BLDELIVERY_QUANTITY),sum(BLBACKLOG)
from BACKLOG left join TURNOVER_PC_CS on BLPCID=TO6PCID
join CUSTOMERS on TO6CSID=CSID and CSUSID1=56 and CSGPID3=65
where TO6PCID is null
group by BLPCID
but I don't get the right results. Any idea, where the error could be?
Regards
Guido