[AccessD] Access 2000 - Union query

dave sharpe davesharpe2 at cox.net
Fri Jan 31 18:37:01 CST 2003


Windows2000 Access 2000

I'm trying to use "UNION" the first time.
I have no problem as a select query, but
I can't get it to work as an append query.

All fiels in all tables are 50 chr strings. Appending
either withour any UNION causes no problem.

I can "work around" by using the UNION query
as the source for an append query

Any pointers on the following will be 
appreciated.

Dave

==========================================
This works

SELECT Table1.Field1, Table1.Field2
FROM Table1

UNION SELECT Table1.Field1, Table1.Field2
FROM Table2;
==========================================
This doesn't, access points to an error in
the second select statement

INSERT INTO Table12 ( Field1, Field2 )

SELECT Table1.Field1, Table1.Field2
FROM Table1

UNION SELECT Table2.Field1, Table2.Field2
FROM Table2;




More information about the AccessD mailing list