Without relevant DDL and sample data we can't really help you. Mark
On 4-1-2018 12:36, Luigi Siciliano [email protected] [firebird-support] wrote: > Hallo, > > The following query works fine but returns *all nulls* if no rows > between :DaData and :AData > > SELECT > > DEPOSITO_ID, > RIPORTO, > CARICO, > SCARICO, > RIPORTO + ESISTENZA AS ESISTENZA, > IMPEGNATI, > ORDINATI > FROM > ( > SELECT > DT.DEPOSITO_ID, > (SELECT > SUM(DC2.CARICO - DC2.SCARICO) > FROM > DOC_CORPO DC2, > DOC_TESTA DT2 > WHERE > DC2.DOC_TESTA_ID = DT2.ID > AND DC2.ARTICOLO_ID = :ID > AND DT2.DATA < :DaData > ) AS RIPORTO, > SUM(DC.CARICO) as Carico, > SUM(DC.SCARICO) as Scarico, > SUM(DC.CARICO - DC.SCARICO) as ESISTENZA, > SUM(DC.IMPEGNATI) as Impegnati, > SUM(DC.ORDINATI) as Ordinati > FROM > DOC_CORPO DC, DOC_TESTA DT > WHERE > DC.DOC_TESTA_ID = DT.ID > AND DC.ARTICOLO_ID = :ID > AND DT.DATA >= :DaData > AND DT.DATA <= :AData > GROUP BY > DT.DEPOSITO_ID > ) > > How I can modify it? > > Thanks. > -- Mark Rotteveel
