Union query with maketable

  • Thread starter Thread starter m miller
  • Start date Start date
M

m miller

Hi all,

I am a MSAccess newbie, I usually work with .NET, SQLServer, Oracle, etc.

I'm trying to create a maketable query that uses UNION syntax and MSAccess
doesn't seem to like
any of my variations and gives me the error:

'An action query cannot be used as a row source.'


Here are my syntax:

select * INTO TEST4
FROM TEST

UNION SELECT * FROM TEST2

UNION SELECT * FROM TEST3

What would the MSAccess syntax be? This works in SQLServer, Oracle and
Foxpro.

TIA,
Marc Miller
 
create a union query & use that as the source, is one solution
(i didn't know oracle supported select .. into ;-))

hth

pieter
 
Pieter,

Thanks, I would never have thought of it.
(btw, your right Oracle insists on being burdensome with create table and
insert into).

Marc Miller
 
What would the MSAccess syntax be?
Click to expand...

Create and save a UNION SELECT query, and then base the action query
on *this* query:

1. Save

SELECT * From TableA
UNION
SELECT * From TableB
UNION
SELECT * Form TableC

as uniABC;

2.

INSERT INTO TableX
SELECT * FROM uniABC;
 
Back
Top