SQL help requested - "linked list"

Hi Everyone,

I have a query I'm trying to do, and with my limited SQL knowledge I don't know how to go about it.

Here's a simplified description of my challenge. I have data in a table that forms sets you might describe as singly-linked lists. For example, the table contains columns ID and NEXTID, where NEXTID points to the ID of some other row. The linked list ends when NEXTID has a zero value.

Given one of the ID values (they're unique), I want to select the IDs that occur before and after in that particular linked list. In a differnet language I would approach this using a recursive function. Is this possible in SQL?

-Mia Received on Thu Aug 21 2003 - 10:36:25 CDT