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.

PS: Sorry my bad english.

----- Original Message -----
From: Martijn Tonies
To: firebird-support@yahoogroups.com
Sent: Monday, September 05, 2005 10:40 AM
Subject: Re: [firebird-support] Subselect error




> 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,
> FROM NotasVenda NV
> INNER JOIN NotasVenda_Valores NVV ON NV.Fil_Codigo =
> NVV.Fil_Codigo AND NV.Ser_Codigo = NVV.Ser_Codigo
> AND NV.NF_Numero =
> NVV.NF_Numero)
> LEFT JOIN ParametrosContabeis PC ON NV.OpFis_Codigo =
> PC.OpFis_Codigo
> AND NV.OrFis_Codigo =
> PC.OrFis_Codigo)
> WHERE NV.NF_DataLcto
> BETWEEN '01/01/2005' AND '12/31/2006'
> GROUP BY NV.OpFis_Codigo
>
> In the interbase, my select worked, now doesnt´t work.

Change it until "it works" again then.

Or perhaps, tell us the error message so we can make an educated guess.

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



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




------------------------------------------------------------------------------
YAHOO! GROUPS LINKS

a.. Visit your group "firebird-support" on the web.

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


------------------------------------------------------------------------------



[Non-text portions of this message have been removed]