Re: Full Outer Join?


David Kerber wrote:
In article <1158071015.584943.82760@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
zeldorblat@xxxxxxxxx says...

khalil.tahir@xxxxxxxxx wrote:
Hi All !

Is Full Outer 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.

Sybase's Adaptive Server Anywhere (AKA SQLAnywhere) does.

--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).

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).

.

Relevant Pages

  • RE: Import from Sybase SQL Anywhere 9
    ... I found similar issue reported and it seems to be caused by olddb driver ... searching the Sybase newsgroups for information on configuring the Sybase ... ianywhere.com support staff. ... Migrating a Microsoft Access Application into a .NET Solution that Uses SQL ...
    (microsoft.public.sqlserver.dts)
  • Re: Sybase to Access
    ... I've had Access apps with 25 mb of data that can't support a half dozen ... MDB shouldn't be used for a single user nor a single record. ... If MS had a decade-long policy of preaching SQL over MDB then _MAYBE_ I ... Access could use link tables to link to Sybase perhaps and give ...
    (microsoft.public.dotnet.languages.vb)
  • Slowly (VERY slowly) writing Tdbc driver for Sybase
    ... Use Sybase' pub* databases for accompanying unit test code. ... No support for DBLib. ... This seems to be an open question. ... I think Sybase has a Japanese pub, ...
    (comp.lang.tcl)
  • Re: combining inner and outer joins
    ... the query that works for you in Sybase, and the output you're looking for. ... > I've recently switched from Sybase to SQL Server, ... > of an outer join clause. ...
    (microsoft.public.sqlserver.programming)
  • RE: asp not retrieving correct information from a query
    ... dbo.DISTRIBUIDORES DISTRIBUIDORES1 RIGHT OUTER JOIN ... dbo.CAT_STATUS_SOLICITUD INNER JOIN ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.inetserver.asp.db)