double linked list

From: Juergen <jasche_at_gmx.de>
Date: 28 Jan 2003 07:44:29 -0800
Message-ID: <2ee07259.0301280744.582e4b7c@posting.google.com>

Hi folks!,

I've got a table called 'link_t' containing a collection of seller - buyer relations between two parties.

sql> select * from link_t

S B
- -

C X
A B
B C
C D
D E

5 rows selected.

I am looking for a select statement that returns the concatenation of seller - buyer relations between the first seller 'A' and the last buyer 'B'.

the result should be

S B
- -

A B
B C
C D
D E

Currently I fumbling around with self joins but haven't figured out yet.
Any suggestions

Many tanks in advance

Cheers

Juergen Received on Tue Jan 28 2003 - 09:44:29 CST