I tried running a query

(t1 union t2) union t3

and I get a parse error. However if I break the query down in these lines:

t4 := t1 union t2;
t4 union t3;

everything works fine. I would rather use the first query. Can anyone
explain why I can't do the first query on Oracle 9i?




-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Did you try it without the parentheses? If you would post a more complete
code sample, it would be easier to give you a better response.

--
Cheers,
Chris

___________________________________

Chris Leonard, The Database Guy
http://www.databaseguy.com

Brainbench MVP for Oracle Admin
http://www.brainbench.com

MCSE, MCDBA, OCP, CIW
___________________________________

"Kim" <khd000 (AT) yahoo (DOT) ca> wrote

Works even *with* parentheses. So, yes, please explain your problem
better.


17:28:15 flado@ax8i>(select * from dual union select * from dual)
union select * from dual;

D
-
X

1 row selected.