Using SUM in a special way

[Mauricio Pellegrini]

Hi,
  I would like to use SUM or any other function to sum a series of
records as in the following example.

I have this table T1

        Col1    Col2 
        1       20
        2       10
        1       10
        2        5
        1       20
        3       10

and would like to obtain this result from a query

        Col1    Col2    Col3
        1       20      20
        1       10      30
        1       20      50
        2       10      10
        2        5      15
        3       10      10

Column Col3 should carry forward and sum values from Col2

Is that possible ?, with SQL I mean...


Thank you 
Mauricio




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]