INSERT INTO Table & Union Query

[eerich]

Hello everyone,

I'm running into problems when trying to append to a table using the following union query. Any help is appreciated:

Select * INTO AU4

FROM
(SELECT Profile, Text, Status
FROM UPR)

UNION

(SELECT Profile, Text, Status
FROM UPR2);

 

[eerich]

Actually figured this out:

SELECT * INTO AU4
FROM
(SELECT Profile, Text, Status
FROM UPR

UNION

SELECT Profile, Text, Status
FROM UPR2);

 

[eerich]

Oops...maybe not...still can't use INSERT INTO existing table. Any tips on getting it to work with an existing table?

 

[Golom]

Try

INSERT INTO SomeTable (Profile, Text, Status)

SELECT Profile, Text, Status
FROM
(SELECT Profile, Text, Status FROM UPR

UNION

SELECT Profile, Text, Status FROM UPR2);

 

[eerich]

Golom,

That worked beautifully.

Thanks!