Hi All !
Is Full Join is supported by Sybase ASE 12.x? If yes, can someone
please explain me what syntax is to be used?
Thanks.

khalil.tahir@gmail.com wrote:
Hi All !
Is Full Join is supported by Sybase ASE 12.x? If yes, can someone
please explain me what syntax is to be used?
Thanks.
Nope -- yet another feature that Sybase does not support directly.

ZeldorBlat wrote:

So, in other words, Sybase feels that features like full outer joins
(which are supported by most other database servers) is only useful in
"database-powered applications for mobile, remote, and small- to
medium-sized business environments" (ASA) but /not/ in
"mission-critical, transaction-intensive applications" (ASE).

I'd say it's more a case of buying a product that already
supported FJ (which became ASA) while continuing to offer
their own product that did not (directly) support FJ (ASE).

But since a FJ is a union of a LJ and a RJ, we're not
talking about a lack of -support- here, we're talking about
a lack of a keyword.

Larry Coon
University of California

"Larry Coon" <lmcoon_nospam@cox.netwrote in message
news:450752A0.DF0@cox.net
ZeldorBlat wrote:

So, in other words, Sybase feels that features like full outer joins
(which are supported by most other database servers) is only useful in
"database-powered applications for mobile, remote, and small- to
medium-sized business environments" (ASA) but /not/ in
"mission-critical, transaction-intensive applications" (ASE).

I'd say it's more a case of buying a product that already
supported FJ (which became ASA) while continuing to offer
their own product that did not (directly) support FJ (ASE).

But since a FJ is a union of a LJ and a RJ, we're not
talking about a lack of -support- here, we're talking about
a lack of a keyword.
--
Larry Coon
University of California

Indeed. And there are other ways to simulate a full outer join as well.
If you have a copy of my book "Tips, Tricks & Recipes for Sybase ASE", see
section 6.2.5 for an example.

HTH,

Rob V.

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" (new edition!)
"The Complete Sybase ASE Quick Reference Guide" (new edition!)
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:rob@YUR.SPAM.sypron.nl.NT.FR.ME
http://www.sypron.nl
Sypron B.V., PBox 10695, 2501HR Den Haag, The Netherlands