How to query a set of tables with identical structure?

How to query a set of tables with identical structure?

am 06.10.2004 21:49:53 von bwvb

I need to do the same SELECT on a number of tables that have identical
structure (same column names and types). Of course I can query the
tables one by one, but I want the query result as a single result set.
How do I do that?

Regards,
Bertwim van Beest