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 On Sep 10, 2014 11:59 AM, "Luigi Siciliano [email protected] [firebird-support]" <[email protected]> wrote:
> 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 DT.DATA_DOCUMENTO) = 2013 > AND DC.VOCE_ID = V.ID > AND V.CONTRIBUTI = 1 > GROUP BY EXTRACT(YEAR FROM DT.DATA_DOCUMENTO) > > > Second (results: ANNO, IMPOSTA): > select > EXTRACT(YEAR FROM DT.DATA_DOCUMENTO) AS ANNO, > SUM(DC.IMPORTO) AS IMPOSTA > from > DOC_CORPO DC, > DOC_TESTA DT > WHERE > DT.ID = DOC_TESTA_ID > AND DT.DOCUMENTO_ID <> 'PRO' > AND EXTRACT(YEAR FROM DT.DATA_DOCUMENTO) = 2013 > AND DC.VOCE_ID = 'ENPACL' > GROUP BY EXTRACT(YEAR FROM DT.DATA_DOCUMENTO) > > There is a way to merge those two queries to obtain the same result in > one query that results: ANNO, IMPONIBILE, IMPOSTA? > > Thanks. > > -- > > Luigi Siciliano > -------------------------- > > > > ------------------------------------ > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > ------------------------------------ > > Yahoo Groups Links > > > >
