Hallo,
Il 04/01/2018 13.27, Rustam rusta...@ukr.net [firebird-support] ha scritto:
Try use explicit JOIN here:
...
FROM
DOC_CORPO DC, DOC_TESTA DT
Not works because in DT there is not rows between 01/01/2018 and 31/12/2018.
But I solved:
I have another table in database that contains foreign keys for
dt.deposito_id.
I modified the query like this, and now works ok:
SELECT
DEPOSITO_ID,
RIPORTO,
CARICO,
SCARICO,
RIPORTO + ESISTENZA AS ESISTENZA,
IMPEGNATI,
ORDINATI
FROM
(
SELECT
D.ID AS 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
DEPOSITI D
LEFT JOIN DOC_TESTA DT ON D.ID = DT.DEPOSITO_ID,
DOC_CORPO DC
WHERE
DC.ARTICOLO_ID = :ID
AND DT.DATA >= :DaData
AND DT.DATA <= :AData
GROUP BY
D.ID
)
Thanks.
--
Luigi Siciliano
--------------------------
