|
Home > Archive > SQL Anywhere Feedback > June 2005 > Will we see multi-column subquery results in Jasper?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Will we see multi-column subquery results in Jasper?
|
|
| Martin Baur 2005-06-07, 8:23 pm |
| Hi there
As written in the subject .... will Jaspers allow multi-column returns for subselects like this
where (col_a, col_b) in (select col_c, col_d from .... )
Oracle has such a thingy ...
Regards
Martin
| |
| Konstantinov Alex \(ASCRUS\) 2005-06-08, 3:23 am |
| Hi.
"Martin Baur" <tinu@mindpower.com> wrote in message
news:MPG. 1d101ae4ad20e0899898
05@forums.sybase.com...
> Hi there
>
> As written in the subject .... will Jaspers allow multi-column returns for
> subselects like this
>
> where (col_a, col_b) in (select col_c, col_d from .... )
>
> Oracle has such a thingy ...
Than bad such variant ? :WHERE EXISTS( SELECT * FROM Table WHERE col_c =
col_a AND col_d = col_b)
| |
| Martin Baur 2005-06-08, 9:23 am |
| In article <42a66a3c@forums-1-dub>, "Konstantinov Alex \(ASCRUS\)" <ascrus@mail.tascom.ru> says...
> Hi.
>
> "Martin Baur" <tinu@mindpower.com> wrote in message
> news:MPG. 1d101ae4ad20e0899898
05@forums.sybase.com...
>
> Than bad such variant ? :WHERE EXISTS( SELECT * FROM Table WHERE col_c =
> col_a AND col_d = col_b)
No, I know that my example was artificial ... Oracle has this feature and I had situations where I coujld use such a notation. I know that the query optimizer will rewrite the query later in the way
you mention ....
| |
| Glenn Paulley 2005-06-08, 9:23 am |
| Martin Baur <tinu@mindpower.com> wrote in
news:MPG. 1d101ae4ad20e0899898
05@forums.sybase.com:
> Hi there
>
> As written in the subject .... will Jaspers allow multi-column returns
> for subselects like this
>
> where (col_a, col_b) in (select col_c, col_d from .... )
>
> Oracle has such a thingy ...
>
>
> Regards
>
> Martin
The short answer is no. The somewhat longer answer is that we are aware
of this Oracle feature and may implement it in a future release.
--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering
EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all
To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288
| |
| Paul Horan[TeamSybase] 2005-06-09, 1:23 pm |
| "Martin Baur" <tinu@mindpower.com> wrote in message news:MPG. 1d110ecf1634aff19898
06@forums.sybase.com...
> In article <42a66a3c@forums-1-dub>, "Konstantinov Alex \(ASCRUS\)" <ascrus@mail.tascom.ru> says...
>
> No, I know that my example was artificial ... Oracle has this feature and I had situations where I coujld use such a
> notation. I know that the query optimizer will rewrite the query later in the way
> you mention ....
>
Yes, but isn't this the same as using derived tables in the FROM clause?
Select
st.col_a,
st.col_b,
foo.col_c,
foo.col_d
from
someTable st,
(Select col_c, col_d from someOtherTable) as foo
where
st.col_a = foo.col_c and
st.col_b = foo.col_d
--
Paul Horan[TeamSybase]
|
|
|
|
|