> It´s result in other error : "Cannot use an aggregate function in a GROUP

BY clause"

Hmm... what version of Firebird?

Can you do a GROUP BY ..., Base17


With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

>
>
> Hi,
>
> > The error : "Invalid expression in the select list(not contained in

either

> an aggregate function or the
> > GROUP BY clause)"
> >
> > I think that for subselect uses the same table, but with the different
> nickname.
> >
> >
> > > SELECT NV.OpFis_Codigo, SUM(NV.NF_VlrNota) as totContabil,
> > > SUM(NVV.NF_VlrBaseICMS27) as Base27,
> > > (SELECT SUM(NVV.NF_BaseICMSX) FROM NotasVenda_Valores

NVV2

> > > WHERE NVV2.Fil_Codigo = NVV.Fil_Codigo AND
> > > NVV2.Ser_Codigo = NVV.Ser_Codigo AND
> > > NVV2.NF_Numero = NVV.NF_Numero AND NVV2.NF_AliqICMSX

=

> > > 17 ) AS Base17,
>
> The "Base17" result column isn't in an aggregate (eg "group by").
>
> Try to extend the "group by" column like this:
>
> GROUP BY NV.OpFis_Codigo, 4