Re: Complicated UNION query
  Home FAQ Contact Sign in
comp.databases.mysql only
 
Advanced search
POPULAR GROUPS

more...

comp.databases.mysql Profile…
 Up
Re: Complicated UNION query         


Author: Christopher Pomasl
Date: Mar 21, 2007 17:39

The GROUP BY is based on the subselect not the full select so each SELECT
statement in the UNION needs its own GROUP BY.

CJP

On Wed, 21 Mar 2007 15:48:42 +0100, JalaL wrote:
>
> "Captain Paralytic" yahoo.com> a écrit dans le message de
> news: 1174469847.705000.117660@n59g2000hsh.googlegroups.com...
>> On 21 Mar, 01:49, "JalaL" nospam.com> wrote:
>...
Show full article (1.57Kb)
no comments

RELATED THREADS
SubjectArticles qty Group
SUBSTRING in query of queriesmacromedia.coldfusion.cfml_general_discussion ·
US-NJ: Union-Pharmaceutical Sales Representative - Union NJalt.bestjobsusa.jobs.offered ·