Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Chained Table Joining Operation

3 posts in General Discussion Last posting was on 2002-09-03 17:15:46.0Z
Jonathan Posted on 2002-08-30 06:55:59.0Z
From: Jonathan
Date: Fri, 30 Aug 2002 02:55:59 -0400
Newsgroups: ianywhere.public.general
Subject: Chained Table Joining Operation
Message-ID: <DAFF87EFE0FCB8D10026158B85256C25.002615AA85256C25@webforums>
Lines: 4
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:653
Article PK: 3180

Does anybody know when ASA will support Chained Table Joining Operation?

How about other database systems like Oracle, SQL*Server, DB2, MySQL? Do
they support Chained Table Joining Operation?


Stephen Rice Posted on 2002-09-03 15:48:09.0Z
Subject: Re: Chained Table Joining Operation
From: Stephen Rice <srice_nospam@ianywhere.com>
References: <DAFF87EFE0FCB8D10026158B85256C25.002615AA85256C25@webforums>
Organization: iAnywhere Solutions
Message-ID: <Xns927E75C9BFDA4sriceianywherecom@199.93.177.77>
User-Agent: Xnews/L5
Newsgroups: ianywhere.public.general
Date: Tue, 03 Sep 2002 11:48:09 -0400
Lines: 17
NNTP-Posting-Host: 172.31.141.72
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:647
Article PK: 2661

Jonathan wrote in
news:DAFF87EFE0FCB8D10026158B85256C25.002615AA85256C25@webforums:

> Does anybody know when ASA will support Chained Table Joining
> Operation?
>
> How about other database systems like Oracle, SQL*Server, DB2, MySQL?
> Do they support Chained Table Joining Operation?
>

What is Chained Tabe joining? I confess I'm not a SQL Guru and a quick
search of oracle.com yielded nothing useful.

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

Whitepapers, TechDocs, bug fixes are all available through the
iAnywhere Developer Community at http://www.ianywhere.com/developer
------ Please Post ------


Robert Waywell Posted on 2002-09-03 17:15:46.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <DAFF87EFE0FCB8D10026158B85256C25.002615AA85256C25@webforums> <Xns927E75C9BFDA4sriceianywherecom@199.93.177.77>
Subject: Re: Chained Table Joining Operation
Date: Tue, 3 Sep 2002 13:15:46 -0400
Lines: 52
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <wIcGr92UCHA.258@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:645
Article PK: 3175

You might want to take a look at this white paper on TSQL outer join syntax.


Semantics and Compatibility of Transact-SQL Outer Joins
http://www.sybase.com/detail/1,6904,1017447,00.html

Chained outer joins and the issues with them are discussed on page 16.
--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

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

"Stephen Rice" <srice_nospam@ianywhere.com> wrote in message
news:Xns927E75C9BFDA4sriceianywherecom@199.93.177.77...
> Jonathan wrote in
> news:DAFF87EFE0FCB8D10026158B85256C25.002615AA85256C25@webforums:
>
> > Does anybody know when ASA will support Chained Table Joining
> > Operation?
> >
> > How about other database systems like Oracle, SQL*Server, DB2, MySQL?
> > Do they support Chained Table Joining Operation?
> >
>
> What is Chained Tabe joining? I confess I'm not a SQL Guru and a quick
> search of oracle.com yielded nothing useful.
>
> /steve
>
> --
> Stephen Rice
> Technical Services Manager
> iAnywhere Solutions
>
> Whitepapers, TechDocs, bug fixes are all available through the
> iAnywhere Developer Community at http://www.ianywhere.com/developer
> ------ Please Post ------