Sum

[kernel76]

HI and happy new year!
i've a question
i'm beginner for sql programming

ok

there are 2 tables X and Y with 3 field each: a,b,c and a1,b1,c1
i want in Y.c1 the SUM of X.b + Y.b1
They are numeric field
thanks for any reply!

 

[dcx693]

First, I'll say that most users don't suggest storing calculated values (but you probably already knew that). What field are you joining the tables on?

 

[kernel76]

ok the join is on fields X.a and Y.a1

 

[dcx693]

UPDATE x INNER JOIN y ON x.a = y.a1 SET y.c1 = [x].+[y].[b1];

 

[kernel76]

thank'u very much!