IOW:

this worked in 97:  TABLE Qry_1 UNION TABLE Qry_2 but fails in access2000
when I try to run it with the "invalid SQL statement; expected 'DELETE',
'INSERT' " etc.

Thanks!

--
Bill

PhotoSourceFolio webmaster
http://www.*-*-*.com/

The correct syntax, or at least the way most of us define UNION queries is
to specify the fields, either with a wildcard "*" or the specific fields
themselves.

SELECT OrderID from Orders
Union
Select OrderID from [Order Details]

 -- Dev

: Why can't I create a UNION query from the SQL design grid in 2000 like I
did
: in 97:
:
: IOW:
:
: this worked in 97:  TABLE Qry_1 UNION TABLE Qry_2 but fails in access2000
: when I try to run it with the "invalid SQL statement; expected 'DELETE',
: 'INSERT' " etc.
:
: Thanks!
:
: --
: Bill

: PhotoSourceFolio webmaster
: http://www.photosourcefolio.com
:
:

Hi,

Dev... Me, Guru? Well, if YOU finally admit YOU are one too, and only at
that condition!   :-)

TABLE tableName
UNION ALL
TABLE OtherTableName

is also a valid syntax. In fact, "TABLE TableName" can be use instead of
"SELECT * FROM TableName"... but the syntax SELECT tableName.. it doesn't
work in Access 97 either.

Vanderghast, Access MVP.

: Hi,
:
: Dev... Me, Guru? Well, if YOU finally admit YOU are one too, and only at
: that condition!   :-)

LOL... :-)

:
: TABLE tableName
: UNION ALL
: TABLE OtherTableName
:
:
: is also a valid syntax. In fact, "TABLE TableName" can be use instead of
: "SELECT * FROM TableName"... but the syntax SELECT tableName.. it doesn't
: work in Access 97 either.
:

Cool... I didn't know that.  Thanks for the info.

  -- Dev

Quick personal... where do you guys work (if I can ask), and what do ya'll
do for a living?  Access I presume?

-- jb

: Yeah, well I though I was pretty good until I started coming in here.  =)
:
: Quick personal... where do you guys work (if I can ask),

I work for a MS Solution Provider/Partner.

: and what do ya'll
: do for a living?  Access I presume?

Nope, not me.  I do front-ends (ASP/JScript) and middle-tier (VB).

 -- Dev