double linked list

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 - 16:44:29 CET