>I have to sum two fields. Same field name but in two different tables.
>
>Right now I sum and join but I end-up with two sums for the same Id.
>
>How do I sum everything without intermediate sums (because of the joins) ?
>
>I guess that "where in (select...) would be involved but I'm sot sure how to build this.
Like this, Denis ?
create cursor c1 ;
( ;
Id I ;
)
insert into c1 values (1)
insert into c1 values (2)
create cursor c2 ;
( ;
Id I ;
)
insert into c2 values (3)
insert into c2 values (4)
select sum(id) ;
from ( select sum(id) as Id from c1 ;
union all ;
select sum(id) as Id from c2 ;
) as xxx ;
Gregory