>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 ;