Michael.Koppelgaard
New member
- Local time
- Today, 20:01
- Joined
- Apr 19, 2022
- Messages
- 17
Hi
I want to combine table1 and table2 using union and at the same time write the result to a third table (table3)
I tried this:
SELECT ID INTO TABLE3
FROM Table1;
UNION
SELECT ID INTO TABLE3
FROM Table2;
but I get the error : "an action query cannot be used as a row source"
Is what I'm trying impossible?
I want to combine table1 and table2 using union and at the same time write the result to a third table (table3)
I tried this:
SELECT ID INTO TABLE3
FROM Table1;
UNION
SELECT ID INTO TABLE3
FROM Table2;
but I get the error : "an action query cannot be used as a row source"
Is what I'm trying impossible?