Is it bug or no support?

Tom,

<< Is it bug or no support? >>

Could you give me an example of the SQL that you're trying to execute ?  You
have to include parentheses around the second and subsequent SELECT
statements if using an ORDER BY statement:

SELECT * FROM MyTable
UNION
(SELECT * FROM MyTable)
ORDER BY MyColumn

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks.

I didn't know there must be (..) for second select.

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:B708E8D7-B0F2-4588-BF8A-57CC199185F3@news.elevatesoft.com...
> Tom,
>
> << Is it bug or no support? >>
>
> Could you give me an example of the SQL that you're trying to execute ?
> You have to include parentheses around the second and subsequent SELECT
> statements if using an ORDER BY statement:
>
> SELECT * FROM MyTable
> UNION
> (SELECT * FROM MyTable)
> ORDER BY MyColumn
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Tom,

<< I didn't know there must be (..) for second select. >>

I'll make a note of it in the manual.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<< You have to include parentheses around the second and subsequent SELECT
statements if using an ORDER BY statement: >>

I'm not sure if this requirement is a parser limitation in EDB or something
else, but I hope you'll implement standard SQL syntax/behavior for UNION
with ORDER BY.

Ole Willy Tuv

Ole,

<< I'm not sure if this requirement is a parser limitation in EDB or
something else, but I hope you'll implement standard SQL syntax/behavior for
UNION with ORDER BY. >>

It's a parser limitation.  I can't remember off-hand why it is, but I'll
take another look at it and see what I can find.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<< It's a parser limitation.  I can't remember off-hand why it is, but I'll
take another look at it and see what I can find. >>

Have you fixed it already ?

Standard UNION/ORDER BY syntax seems to work fine with 1.04 b6.

Ole Willy Tuv

Ole

I think it has been fixed.

http://www.elevatesoft.com/scripts/incident.dll?action=viewrep&category=edb&release=1.04&type=f&incident=2414

Eduardo

Ole,

<< Have you fixed it already ?

Standard UNION/ORDER BY syntax seems to work fine with 1.04 b6. >>

Yep.

--
Tim Young
Elevate Software
www.elevatesoft.com