Newbie SQL

Hi,

I have the following table:

SCORE OID TYPE
-------- ------ -------

  60     123    text
  40     124    attach
  37     123    attach
  28     150    attach
  13     123    attach

What is the request to get the following: ( outer join ?? )

CUMUL SCORE OID TYPE
----- ------ ------ -------

 110    60       123    text
 110    40       123    attach
 110    37       123    attach
  40    28       124    attach
  28    13       150    attach

where 110 = 60 + 37 + 13.

Thanks in advance Received on Wed Nov 06 2002 - 15:01:49 CST