[AccessD] Access 2000 - Union query

Stuart - How are things in Papua New Guinea. If you weren't born there,
is there an interesting story about how you happened to migrate there?

I tried every variation that I could think of with no success. It is a small
file  ( only 22Kb zipped ) would you mind looking at it? I completely
understand if you would prefer not to.

Either way thanks for your assistance

Dave

----- Original Message -----
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "dave sharpe" <davesharpe2 at cox.net>; <accessd at databaseadvisors.com>
Sent: Friday, January 31, 2003 10:11 PM
Subject: Re: [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.
>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>