Re: Querying from two tables as if they were appended

am 17.05.2006, um 11:43:59 -0400 mailte David Gaudine folgendes:
> I have two tables with an identical layout. The difference is that one has
> data from this year and one has data from last year. For a simplified
> example let's call them "table05" and "table06", and say that each has a
> single column called "name". So we have
>
> table05:
> David
> Bob
>
> table06:
> David
> John
> Paul
>
> I want to select all rows from both tables, so the result (order not
> important) is
> David
> Bob
> David
> John
> Paul

select col from table05 union all select col from table06;

HTH, Andreas.
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47215, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===