Hallo,
I have two queries:
First (results: ANNO, IMPONIBILE):
select
EXTRACT(YEAR FROM DT.DATA_DOCUMENTO) AS ANNO,
SUM(DC.IMPORTO) AS IMPONIBILE
from
DOC_CORPO DC,
DOC_TESTA DT,
VOCI V
WHERE
DT.ID = DOC_TESTA_ID
AND DT.DOCUMENTO_ID 'PRO'
AND EXTRACT(YEAR FROM
Luigi,
Give this a try.
Select ANNO, MAX(IMPONIBILE), MAX(IMPOSTA) FROM (
select
EXTRACT(YEAR FROM DT.DATA_DOCUMENTO) AS ANNO,
SUM(DC.IMPORTO) AS IMPONIBILE,
0 as IMPOSTA
from
DOC_CORPO DC,
DOC_TESTA DT,
VOCI V
WHERE
DT.ID = DOC_TESTA_ID
AND DT.DOCUMENTO_ID 'PRO'
AND
You could do it with a union.
Your first select would be:
select
EXTRACT(YEAR FROM DT.DATA_DOCUMENTO) AS ANNO,
SUM(DC.IMPORTO) AS IMPONIBILE, 0 AS I POST A
And your second select would be
select
EXTRACT(YEAR FROM DT.DATA_DOCUMENTO) AS ANNO,
0 AS IMPONIBILE,
SUM(DC.IMPORTO) AS IMPOSTA
Hallo,
I have two queries:
First (results: ANNO, IMPONIBILE):
select
EXTRACT(YEAR FROM DT.DATA_DOCUMENTO) AS ANNO,
SUM(DC.IMPORTO) AS IMPONIBILE
from
DOC_CORPO DC,
DOC_TESTA DT,
VOCI V
WHERE
DT.ID = DOC_TESTA_ID
AND DT.DOCUMENTO_ID 'PRO'
AND EXTRACT(YEAR FROM