--Campo 2
(SELECT (COALESCE(SUM(GL.CONT_PAT_APOSEN),0) +
COALESCE(SUM(GL.CONT_PAT_ATIVOS),0) +
COALESCE(SUM(GL.CONT_PAT_DOENCA),0) +
COALESCE(SUM(GL.CONT_PAT_MATERN),0) +
COALESCE(SUM(GL.CONT_PAT_PENSIO),0))
FROM GUIA_PAGAMENTO GP, GUIA_LANCAMENTO GL1
WHERE GP.ID_GUIA_LANCAMEN = GL1.ID_GUIA
AND GL.MES = GL1.MES) AS CAMPO2,
--Campo 3
(SELECT (COALESCE(SUM(GP.CONT_PAT_APOSEN),0) +
COALESCE(SUM(GP.CONT_PAT_ATIVOS),0) +
COALESCE(SUM(GP.CONT_PAT_DOENCA),0) +
COALESCE(SUM(GP.CONT_PAT_MATERN),0) +
COALESCE(SUM(GP.CONT_PAT_PENSIO),0))
FROM GUIA_PAGAMENTO GP, GUIA_LANCAMENTO GL1
WHERE GP.ID_GUIA_LANCAMEN = GL1.ID_GUIA
AND GL.MES = GL1.MES) AS CAMPO3,
--Campo 4
(SELECT (COALESCE(SUM(GB.CONT_PAT_APOSEN),0) +
COALESCE(SUM(GB.CONT_PAT_ATIVOS),0) +
COALESCE(SUM(GB.CONT_PAT_DOENCA),0) +
COALESCE(SUM(GB.CONT_PAT_MATERN),0) +
COALESCE(SUM(GB.CONT_PAT_PENSIO),0))
FROM GUIA_BAIXA GB, GUIA_LANCAMENTO GL1
WHERE GB.ID_GUIA = GL1.ID_GUIA
AND GL.MES = GL1.MES) AS CAMPO4
--Campo5 (CAMPO 1 - CAMPO 2 - CAMPO3)
FROM ORGAO O, GUIA_LANCAMENTO GL
WHERE GL.ANO_COMPETENCIA = 2011
AND GL.ID_ORGAO = O.ID_ORGAO
GROUP BY CAMPO1, CAMPO2, CAMPO3, CAMPO4
Ja tentei de todas as formas corrigir o erro que da se alguem souber fico grato.
Erro:
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Cannot use an aggregate function in a GROUP BY clause.
Edição feita por: Themer, 24/02/2011, 08:18.