|
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
Navigation:
[Reply to this message]
|