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    ===