I'm creating a query that have to return the sum of payment in a month... but, that is returning this error:
Status SQL: 37000 Código de erro: -67 Not in aggregate function or group by clause: [EMAIL PROTECTED] statement [SELECT "pagamentos"."MesRef", "pagamentos"."AnoRef", SUM( "planos"."Valor" ) FROM "pagamentos", "planos" WHERE "pagamentos"."MesRef" = :Mês AND "pagamentos"."AnoRef" = :Ano] How I can do to correct this? P.S.-Sorry for my bad english...
