|
Home > Archive > ASE Database forum > December 2005 > ASE 15 and ANSI standard Join syntax
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 |
ASE 15 and ANSI standard Join syntax
|
|
| M. Searer 2005-11-30, 11:24 am |
| Does ASE 15 FULLY support the ansi standard join syntax?
full outer join
cross join
are missing in the prior release.
This is critical since you can not do a full outer join (Cartesian product) to a
table if you are using LEFT OUTER JOIN to another table in releases prior to ASE
15.
| |
| Rob Verschoor 2005-11-30, 8:25 pm |
| "M. Searer" <nospam@nospam.com> wrote in message
news:438ddb81$1@foru
ms-1-dub...
> Does ASE 15 FULLY support the ansi standard join syntax?
>
> full outer join
> cross join
> are missing in the prior release.
>
> This is critical since you can not do a full outer join (Cartesian
product) to a
> table if you are using LEFT OUTER JOIN to another table in releases prior
to ASE
> 15.
>
The full outer join and cross join are not yet implemented in ASE 15.0 GA.
HTH,
Rob
-------------------------------------------------------------
Rob Verschoor
Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase
Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase Replication Server Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"
mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------
| |
| Carl Kayser 2005-12-01, 7:24 am |
|
Does your response mean that Sybase plans to implement either or both in an
ASE 15.x release?
"Rob Verschoor" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote in
message news:438e2c64@forums
-1-dub...
> "M. Searer" <nospam@nospam.com> wrote in message
> news:438ddb81$1@foru
ms-1-dub...
> product) to a
> to ASE
>
>
> The full outer join and cross join are not yet implemented in ASE 15.0 GA.
>
> HTH,
>
> Rob
> -------------------------------------------------------------
> Rob Verschoor
>
> Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
> and Replication Server 12.5 / TeamSybase
>
> Author of Sybase books (order online at www.sypron.nl/shop):
> "Tips, Tricks & Recipes for Sybase ASE"
> "The Complete Sybase Replication Server Quick Reference Guide"
> "The Complete Sybase ASE Quick Reference Guide"
>
> mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
> http://www.sypron.nl
> Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
> -------------------------------------------------------------
>
>
| |
| Rob Verschoor 2005-12-01, 8:25 pm |
| I know these features are on the 'To do' list, but I do not have information
when these will be done.
You can help to raise the priority of these requests by logging a case with
techsupport requesting these features and ask for your case to be associated
with CR 326743 (for the full outer join) and CR 203737 (for the cross join).
HTH,
Rob V.
"Carl Kayser" <kayser_c@bls.gov> wrote in message
news:438edb84$1@foru
ms-1-dub...
>
> Does your response mean that Sybase plans to implement either or both in
an
> ASE 15.x release?
>
> "Rob Verschoor" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote in
> message news:438e2c64@forums
-1-dub...
prior[color=darkred]
GA.[color=darkred]
>
>
|
|
|
|
|