Using same table to Add data

[alex98]

I have one table:

cno date cname proj1 proj2 proj3
--- ----- ----- ----- ----- ----
101 01/01 john 50 60 70
101 02/01 tom 40 50 90
103 03/01 mike 30 20 10

My two keys are CNO and DATE.
I don't know how to write a query that would
perform an arithmetic fucntion of two consecutive dates or any dates, for example:

ADD proj1 of 101 (50) to proj2 of 101 OR
ADD proj1 of 101 (40) to proj3 of 101.

ON SQL Server....

 

[tlbroadbent]

I can't understand your example in relation to the desciption you provided. Could you clarify a bit please.

Do you want to add values vertically or horizontally? Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm

 

[alex98]

I need to add proj1 to proj2 of dates 01/01 and 01/02, keeping in mind that this is in one table.