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

This is surely trivial, but I read the section about joined tables and
it shows only how to give a result that has 2 columns, like

test=# select * from table05,table06;
name | name
-------+-------
David | David
David | John
David | Paul
Bob | David
Bob | John
Bob | Paul

One solution would to to create a third table and copy the first two
into it, but since the two tables change frequently this is
undesirable. How can I do it by querying the existing tables?

Note: This example is oversimplified. The real query will also test
other columns, like for example
select * from ( however I do the above) where age > 25
so the number of rows in the result will not be the sum of the number of
rows in each table.

David


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly