Re: Append resultset

From: Keith Boulton <boulke_at_globalnet.co.uk>
Date: Mon, 22 Nov 1999 17:36:03 GMT
Message-ID: <3839506d.2899234@read.news.globalnet.co.uk>

On Mon, 22 Nov 1999 10:37:25 GMT, buurd_at_my-deja.com wrote:

> Hi!
>I have to make several queries to solve a problem but there is a small
>catch. I want the results from each and every query to append the same
>resultset. One way I can think of is creating a temporary table but the
>problem is that table must be uniqe for this run. The next user who
>might run the same query at the same time must not use the same
>temporary table.

Can you use the 'union all' statement, this combines the results from multiple queries, so long as they have the same column datatypes e.g.:

select 'x', 1 from sys.dual
union all
select 'y', 2 from sys.dual Received on Mon Nov 22 1999 - 11:36:03 CST