Re: UNION ALL GROUP BY

Article View: es.comp.bd.misc

Article #95

#95

From: -Nacho-
Date: Mon, 06 Feb 2006 12:04

13 lines
1418 bytes

Yo lo haría mediante una sentencia como
SELECT * FROM
(SELECT * FROM x
UNION ALL
SELECT * FROM y
UNION ALL
SELECT * FROM z
)
GROUP BY campo

Prueba a ver
-
Nacho

Technical Details

Message-ID: <1139227442.383250.52630@z14g2000cwz.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!z14g2000cwz.googlegroups.com!not-for-mail

References: <1138796931.428313.166110@o13g2000cwo.googlegroups.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 106e2f,cfe225487bc4fabe
X-Google-Attributes: gid106e2f,public
X-Google-Language: ENGLISH,ASCII
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!z14g2000cwz.googlegroups.com!not-for-mail
From: "-Nacho-" <yoestepario@hotmail.com>
Newsgroups: es.comp.bd.misc
Subject: Re: UNION ALL GROUP BY
Date: 6 Feb 2006 04:04:02 -0800
Organization: http://groups.google.com
Lines: 14
Message-ID: <1139227442.383250.52630@z14g2000cwz.googlegroups.com>
References: <1138796931.428313.166110@o13g2000cwo.googlegroups.com>
NNTP-Posting-Host: 80.38.210.61
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1139227447 26747 127.0.0.1 (6 Feb 2006 12:04:07 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 6 Feb 2006 12:04:07 +0000 (UTC)
In-Reply-To: <1138796931.428313.166110@o13g2000cwo.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.7.10) Gecko/20050717 Firefox/1.0.6,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: z14g2000cwz.googlegroups.com; posting-host=80.38.210.61;
   posting-account=pU1qOQwAAADxplOrBSHd1qL27H7AeR8l

Reply to Parent Message