Article View: borland.public.interbase.sql
Article #415Re: Error with Subquery and Group By
From: Craig Stuntz TeamB
Date: Thu, 06 Mar 2008 13:07
Date: Thu, 06 Mar 2008 13:07
17 lines
1673 bytes
1673 bytes
Adalberto Baldini wrote: > are you saying it is not possible ? Yes. > In this case what could be a solution ? You *may* be able to put the query with the subquery in a VIEW and group that. I haven't tried it. You could certainly put it in a SELECTable proc. -- Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz Everything You Need to Know About InterBase Character Sets: http://blogs.teamb.com/craigstuntz/articles/403.aspx
Technical Details
Message-ID:
<47cffabc$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!194.25.134.126.MISMATCH!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<47cec8df$1@newsgroups.borland.com> <47ceca0b$1@newsgroups.borland.com> <47cfc1ab@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 From: "Craig Stuntz [TeamB]" <craig_stuntz@nospam.please [a.k.a. acm.org]> Subject: Re: Error with Subquery and Group By Newsgroups: borland.public.interbase.sql References: <47cec8df$1@newsgroups.borland.com> <47ceca0b$1@newsgroups.borland.com> <47cfc1ab@newsgroups.borland.com> Organization: Vertex Systems Corporation User-Agent: XanaNews/1.18.1.9 X-Face: "huzh55Xi]!ZNni78>a*5+).`SK?<^q2MlHk-C]Z2M9T@\J5ZCB$95Ey+s"XQuhGFA[eutZ:0^AV!Q;t>gE`1-=8d;HZ6~*o1dH<X9\b$!|(}+I'!Xq)@3Op}%0ArW&nf'Qh*EwR MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit NNTP-Posting-Host: 64.199.116.234 Message-ID: <47cffabc$1@newsgroups.borland.com> Date: 6 Mar 2008 06:07:56 -0700 X-Trace: newsgroups.borland.com 1204812476 64.199.116.234 (6 Mar 2008 06:07:56 -0700) Lines: 17 X-Authenticated-User: cstuntz Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!194.25.134.126.MISMATCH!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail