N
naveen prasad
Dear all,
kindly help me in this.
I have created 2 tables d1,d2
d1 fields are x1,x2;
d2 fields are y1,y2;
All fields are numeric values.
I want to subtract sum(y1) - sum(x1).
for example like below
x1 x2 y1 y1
d1- 20 30 d2- 100 20
10 20 10 10
10 10 10 15
I want to differentiate the sum of y1 -sum of x1
= 120-40 = 80
pls note. there is no primary key matching in both tables.
kindly help me in this case.
regards
kindly help me in this.
I have created 2 tables d1,d2
d1 fields are x1,x2;
d2 fields are y1,y2;
All fields are numeric values.
I want to subtract sum(y1) - sum(x1).
for example like below
x1 x2 y1 y1
d1- 20 30 d2- 100 20
10 20 10 10
10 10 10 15
I want to differentiate the sum of y1 -sum of x1
= 120-40 = 80
pls note. there is no primary key matching in both tables.
kindly help me in this case.
regards