In article <20071024132516.GI19546@xxxxxxxxxxxxxxx>,
"A. Kretschmer" <andreas.kretschmer@xxxxxxxxxxxxxx> 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.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
