Posted by Hiho on 01/24/08 13:23

Thanks for your answers

P. Ratchev :

> Is this a valid query? I mean if the UNION of the two SELECT statements
> returns more than a single value then you will get an error (at least on SQL
> Server).

Fortunately, it's impossible that the UNION returns more than 1
value ! Thanks for your explanations...


S. Rielau :

> > SELECT
> > x1,
> > x2,
>
>
> X.x3
> FROM ... ,
>
>
> > ( SELECT ... FROM ... WHERE ...
> > UNION
> > SELECT ... FROM ... WHERE ...) as X.x3

Unfortunately, this can't work in my case, because, in my case, I
would have :
SELECT ...
FROM X,
(SELECT ... FROM Y WHERE Y.a=X.a
UNION
............)

The 2nd "FROM" depends on the 1st.

Sorry, I shoud be more precise.

Hiho

[Back to original message]