Make Table & Union query

[SusanV]

Hi all,

is it possible to make a table based on a Union query in a single SQL
statement? Or must I create the table first then append each piece of the
union query? (I don't want to store the union query)

TIA,

Susan

 

[Brian Camire]

You might try something like:

SELECT
*
INTO
[Destination Table]
FROM
(SELECT
[Origin Table 1].[Field 1],
[Origin Table 1].[Field 2]
FROM
[Origin Table 1]
UNION SELECT
[Origin Table 2].[Field 1],
[Origin Table 2].[Field 2]
FROM
[Origin Table 2])

 

[SusanV]

Thanks Brian - I'll give that a try.

You might try something like:

SELECT
*
INTO
[Destination Table]
FROM
(SELECT
[Origin Table 1].[Field 1],
[Origin Table 1].[Field 2]
FROM
[Origin Table 1]
UNION SELECT
[Origin Table 2].[Field 1],
[Origin Table 2].[Field 2]
FROM
[Origin Table 2])

Hi all,

is it possible to make a table based on a Union query in a single SQL
statement? Or must I create the table first then append each piece of the
union query? (I don't want to store the union query)

TIA,

Susan