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