Re: "Concatenate" two queries - how?

In article <20071024132516.GI19546@a-kretschmer.de>,
"A. Kretschmer" <andreas.kretschmer@schollglas.com> writes:

> am  Wed, dem 24.10.2007, um 15:08:51 +0200 mailte Stefan Schwarzer folgendes:
>> Now, I want to enable queries which display national as well as
>> regional values. I could probably work with independent queries, but
>> I think it would be "cleaner" and more efficient to get everything
>> into a single query.
>>
>> Can someone give me a hint how this would work?
>>
>> Thanks a lot!

> select ... UNION select ...

Apparently Stefan doesn't know about UNION, and thus he probably
doesn't know that UNION ALL is almost always preferrable.