bug in access query saves?

[Kent Eilers]

The following query changes when I save it:
=============== =============== =============== =============== ======
SELECT
AcctID
FROM
(SELECT
[order number] as AcctID
FROM tblOrderHeader

UNION

SELECT
[AcctID]
from tblExDoc

UNION SELECT
[INVOICE] as AcctID
FROM tblSalesInvoice Header
)

When i save it and reopen it - it morphs into the following (note the last
line):

SELECT AcctID
FROM [SELECT
[order number] as AcctID
FROM tblOrderHeader

UNION

SELECT
[AcctID]
from tblExDoc

UNION SELECT
[INVOICE] as AcctID
FROM tblSalesInvoice Header
]. AS [%$##@_Alias];

=============== =============== =============== =============== ======
Does Access2k not support Select statements in the FROM clause? Or is
something else going on?

Thanks
--
kent eilers
ke**@kaeService s.com

[DFS]

Kent,

You can change that last part [%$##@_Alias] to [anything you want] and it
won't affect the query results.

What you might be concerned with is your usage of AcctID, Order Number and
Invoice. You seem to be using them interchangeably , and you probably don't
want to do that.

"Kent Eilers" <ka*****@uswest .net> wrote in message
news:yU******** *************@t wister.rdc-kc.rr.com...

The following query changes when I save it:
=============== =============== =============== =============== ======
SELECT
AcctID
FROM
(SELECT
[order number] as AcctID
FROM tblOrderHeader

UNION

SELECT
[AcctID]
from tblExDoc

UNION SELECT
[INVOICE] as AcctID
FROM tblSalesInvoice Header
)

When i save it and reopen it - it morphs into the following (note the last
line):

SELECT AcctID
FROM [SELECT
[order number] as AcctID
FROM tblOrderHeader

UNION

SELECT
[AcctID]
from tblExDoc

UNION SELECT
[INVOICE] as AcctID
FROM tblSalesInvoice Header
]. AS [%$##@_Alias];

=============== =============== =============== =============== ======
Does Access2k not support Select statements in the FROM clause? Or is
something else going on?

Thanks
--
kent eilers
ke**@kaeService s.com

[Kent Eilers]

Thanks - the differences in field names are due to legacy issues with the
project.

what i got to work - which didn't get munched by the Access query parser is
the following - note that this is access 97 syntax! It would appear that
Access2k's query parser converted my ansi standard (with parenthesis's) to
the bracket'ed version of access '97.

SELECT a.*
FROM [SELECT
[order number] as AcctID
FROM tblOrderHeader

UNION

SELECT
AcctID
from tblExDoc

UNION

SELECT
INVOICE as AcctID
FROM tblSalesInvoice Header
]. AS a
ORDER BY 1;
"DFS" <no******@nospa m.com> wrote in message
news:vs******** ****@corp.super news.com...

Kent,

You can change that last part [%$##@_Alias] to [anything you want] and it
won't affect the query results.

What you might be concerned with is your usage of AcctID, Order Number and
Invoice. You seem to be using them interchangeably , and you probably don't want to do that.

"Kent Eilers" <ka*****@uswest .net> wrote in message
news:yU******** *************@t wister.rdc-kc.rr.com...

The following query changes when I save it:
=============== =============== =============== =============== ======
SELECT
AcctID
FROM
(SELECT
[order number] as AcctID
FROM tblOrderHeader

UNION

SELECT
[AcctID]
from tblExDoc

UNION SELECT
[INVOICE] as AcctID
FROM tblSalesInvoice Header
)

When i save it and reopen it - it morphs into the following (note the last line):

SELECT AcctID
FROM [SELECT
[order number] as AcctID
FROM tblOrderHeader

UNION

SELECT
[AcctID]
from tblExDoc

UNION SELECT
[INVOICE] as AcctID
FROM tblSalesInvoice Header
]. AS [%$##@_Alias];

=============== =============== =============== =============== ======
Does Access2k not support Select statements in the FROM clause? Or is
something else going on?

Thanks
--
kent eilers
ke**@kaeService s.com

[DFS]

"Kent Eilers" <ka*****@uswest .net> wrote in message
news:UI******** ************@tw ister.rdc-kc.rr.com...

Thanks - the differences in field names are due to legacy issues with the
project.
Sure thing.

Is it worth your time to fix those issues so it doesn't become _your_
legacy?
what i got to work - which didn't get munched by the Access query parser is the following - note that this is access 97 syntax! It would appear that
Access2k's query parser converted my ansi standard (with parenthesis's) to
the bracket'ed version of access '97.

SELECT a.*
FROM [SELECT
[order number] as AcctID
FROM tblOrderHeader

UNION

SELECT
AcctID
from tblExDoc

UNION

SELECT
INVOICE as AcctID
FROM tblSalesInvoice Header
]. AS a
ORDER BY 1;
"DFS" <no******@nospa m.com> wrote in message
news:vs******** ****@corp.super news.com...

Kent,

You can change that last part [%$##@_Alias] to [anything you want] and it

won't affect the query results.

What you might be concerned with is your usage of AcctID, Order Number and Invoice. You seem to be using them interchangeably , and you probably

don't

want to do that.

"Kent Eilers" <ka*****@uswest .net> wrote in message
news:yU******** *************@t wister.rdc-kc.rr.com...

The following query changes when I save it:
=============== =============== =============== =============== ======
SELECT
AcctID
FROM
(SELECT
[order number] as AcctID
FROM tblOrderHeader

UNION

SELECT
[AcctID]
from tblExDoc

UNION SELECT
[INVOICE] as AcctID
FROM tblSalesInvoice Header
)

When i save it and reopen it - it morphs into the following (note the

last line):

SELECT AcctID
FROM [SELECT
[order number] as AcctID
FROM tblOrderHeader

UNION

SELECT
[AcctID]
from tblExDoc

UNION SELECT
[INVOICE] as AcctID
FROM tblSalesInvoice Header
]. AS [%$##@_Alias];

=============== =============== =============== =============== ======
Does Access2k not support Select statements in the FROM clause? Or is
something else going on?

Thanks
--
kent eilers
ke**@kaeService s.com

[Kent Eilers]

not what i'm getting paid for ))
"DFS" <no******@nospa m.com> wrote in message
news:vs******** ****@corp.super news.com...

"Kent Eilers" <ka*****@uswest .net> wrote in message
news:UI******** ************@tw ister.rdc-kc.rr.com...

Thanks - the differences in field names are due to legacy issues with the

project.

Sure thing.

Is it worth your time to fix those issues so it doesn't become _your_
legacy?

what i got to work - which didn't get munched by the Access query parser

is

the following - note that this is access 97 syntax! It would appear that Access2k's query parser converted my ansi standard (with parenthesis's) to the bracket'ed version of access '97.

SELECT a.*
FROM [SELECT
[order number] as AcctID
FROM tblOrderHeader

UNION

SELECT
AcctID
from tblExDoc

UNION

SELECT
INVOICE as AcctID
FROM tblSalesInvoice Header
]. AS a
ORDER BY 1;
"DFS" <no******@nospa m.com> wrote in message
news:vs******** ****@corp.super news.com...

Kent,

You can change that last part [%$##@_Alias] to [anything you want] and it won't affect the query results.

What you might be concerned with is your usage of AcctID, Order Number and Invoice. You seem to be using them interchangeably , and you probably

don't

want to do that.

"Kent Eilers" <ka*****@uswest .net> wrote in message
news:yU******** *************@t wister.rdc-kc.rr.com...
> The following query changes when I save it:
> =============== =============== =============== =============== ======
> SELECT
> AcctID
> FROM
> (SELECT
> [order number] as AcctID
> FROM tblOrderHeader
>
> UNION
>
> SELECT
> [AcctID]
> from tblExDoc
>
> UNION SELECT
> [INVOICE] as AcctID
> FROM tblSalesInvoice Header
> )
>
> When i save it and reopen it - it morphs into the following (note the last

> line):
>
> SELECT AcctID
> FROM [SELECT
> [order number] as AcctID
> FROM tblOrderHeader
>
> UNION
>
> SELECT
> [AcctID]
> from tblExDoc
>
> UNION SELECT
> [INVOICE] as AcctID
> FROM tblSalesInvoice Header
> ]. AS [%$##@_Alias];
>
> =============== =============== =============== =============== ======
> Does Access2k not support Select statements in the FROM clause? Or

is > something else going on?
>
> Thanks
> --
> kent eilers
> ke**@kaeService s.com
>
>