[AccessD] Access 2000 - Union query

> 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;
> 

Try using brackets to ensure that the Union is applied to the correct part.

INSERT INTO Table12 ( Field1, Field2 )
(SELECT Table1.Field1, Table1.Field2
 FROM Table1
  UNION SELECT Table2.Field1, Table2.Field2
 FROM Table2);
 






-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.