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.

Hierarchical Queries in Sybase

2 posts in Windows NT Last posting was on 1997-11-25 16:57:08.0Z
Charanjiv Posted on 1997-11-25 09:43:46.0Z
Message-ID: <347A9DD2.744C@hotmail.com>
Date: Tue, 25 Nov 1997 15:13:46 +0530
From: Charanjiv <cskalha@hotmail.com>
Reply-To: cskalha@hotmail.com
Organization: SSI
X-Mailer: Mozilla 3.01 (Win95; I)
MIME-Version: 1.0
Subject: Hierarchical Queries in Sybase
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 5
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5395
Article PK: 1081474

Hi there

Can any one tell me any way to write Hierarchical Quieries in Sybase
like we could in Oracle using the start with connect by clause.

Charanjiv


Bret Halford Posted on 1997-11-25 16:57:08.0Z
Message-ID: <347B0364.5BB1@sybase.com>
Date: Tue, 25 Nov 1997 09:57:08 -0700
From: Bret Halford <bret@sybase.com>
Organization: Customer Service & Support
X-Mailer: Mozilla 3.0 (X11; U; SunOS 5.5.1 sun4m)
MIME-Version: 1.0
To: cskalha@hotmail.com
Subject: Re: Hierarchical Queries in Sybase
References: <347A9DD2.744C@hotmail.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 12
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5394
Article PK: 1081476


Charanjiv wrote:
>
> Hi there
>
> Can any one tell me any way to write Hierarchical Quieries in Sybase
> like we could in Oracle using the start with connect by clause.
>

see the "Advanced SQL" section in the comp.databases.sybase FAQ:

http://reality.sgi.com/pablo/Sybase_FAQ


--
Bret Halford Imagine my disappointment
Sybase Technical Support in learning the true nature
3665 Discovery Drive of rec.humor.oracle...
Boulder, CO 80303