When using a GROUP BY, or SUM or other aggregate
function, you need to use one on each column.

Both of these columns are not mentioned in the GROUP BY
clause.

> Hi, I receive this error when I put this two fields in sql.
> d.DESCRICAO_DISCIPLINA_PADRAO,
> extract(year from c.DATA_INICIO) Ano
>
>
> select
> da.ID_CURSO,
> da.ID_DISCIPLINA,
> da.ID_ALUNO,
> sum(da.NOTA_DIARIO) Nota,
> sum(da.QTD_FALTA_DIARIO) Faltas,
> d.DESCRICAO_DISCIPLINA_PADRAO,
> extract(year from c.DATA_INICIO) Ano
> from DIARIO_ALUNO da
> left join DISCIPLINA d on d.ID_DISCIPLINA = da.ID_DISCIPLINA
> left join CURSO c on c.ID_CURSO = da.ID_CURSO
> where da.ID_ALUNO = :id_aluno and da.ID_CURSO = :id_curso
> group by da.ID_CURSO, da.ID_DISCIPLINA, da.ID_ALUNO

With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

See you at the First European Firebird Conference in May in Fulda, Germany
http://www.firebird-conference.com