>hi all :
>
>Hi was trying to make a column with the total's of the other two and paste the result to the next row .... more or less like this:
>
>Col a - Col b = total
>10 0 10
>0 15 -5
>
>Etc...
>Can i do This with a SQL ? I tryed to use :
>SELECT a,b, SUM(a+b) as total
>but it always gives me just one record (with -5)!
>
>Thanks in Advance !

Don't use the SUM(), SUM() will always go an aggregate based on either ALL RECORDS, or a given group by...

select a, b, a-b as total from mytable...