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), and what do ya'll
do for a living? Access I presume?
-- jb
Quote:
> 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.
> > Hmm.... I've never defined UNION queries that way. In fact, I'm pretty
> sure
> > that _that's_ an invalid syntax, but I'll leave it up for a SQL guru
like
> > Vanderghast to
> > help me on.
> > 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
> > :
> > :