Re: Error with Subquery and Group By

Article View: borland.public.interbase.sql

Article #414

Back to borland.public.interbase.sql Previous Next

#414

From: Adalberto Baldini
Date: Thu, 06 Mar 2008 10:04

21 lines
1589 bytes

Only to understand you reply :

Craig Stuntz [TeamB] wrote:

> 
> 	When you (1) have an aggregate 
any max, sum column ?

and (2) do a group by, you *must*
> include all non-aggregate fields in the GROUP BY. 

But you don't include the subquery in that
I tried to do it referring to this column with an alias name or with the 
column number but it doesn't work.

  (nor can you),
  are you saying it is not possible ? In this case what could be a 
solution ?

Thanks
Adalberto

Technical Details

Message-ID: <47cfc1ab@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <47cec8df$1@newsgroups.borland.com> <47ceca0b$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,5277ddb39d374d09
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Thu, 06 Mar 2008 11:04:29 +0100
From: Adalberto Baldini <finman@swissonline.ch>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: Error with Subquery and Group By
References: <47cec8df$1@newsgroups.borland.com> <47ceca0b$1@newsgroups.borland.com>
In-Reply-To: <47ceca0b$1@newsgroups.borland.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 080306-0, 06/03/2008), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 83.76.148.66
Message-ID: <47cfc1ab@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1204797867 83.76.148.66 (6 Mar 2008 02:04:27 -0700)
Lines: 21
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message