Exactly! thank you.

>>

>select CodeField, ;
>         SUM( SumForFieldTotal ) as SumForFieldTotal, ;
>        SUM( SumForFieldQuant) as SumForFieldQuant, ;   
>       Field3 ;
> from ( ;
>    ;
>>SELECT  Table1.cod as CodeField,  ;
>>	SUM( Table1.total) as SumForFieldTotal, ;
>>	SUM( Table1.quant) as SumForFieldQuant, ;
>>	Field3 ;
>>FROM Table1 ;
>>JOIN table3  ;
>>ON Table1.cod = table3.code ;
>>where table3.field4 = 1  ;
>>GROUP BY Field3, CodeField ;
>>UNION ALL select  ;
>>	table2.cod as CodeField, ;
>>	sum( table2.total) as SumForFieldTotal, ;
>>	sum( table2.quant) as SumForFieldQuant,  ;
>>	Field3  ;
>>	FROM table2 ;
>>	JOIN table3  ;
>>	ON table2.cod = table3.code  ;
>>	WHERE table3.field4 = 1 ;	
>>	GROUP BY Field3, CodeField ;
>>ORDER BY CodeField ;
>  ;
>  ) as xxx ;
>GROUP BY Field3, CodeField ;
>ORDER BY CodeField
>
>>

>
>
>
>>

>>SELECT  Table1.cod as CodeField,  ;
>>	SUM( Table1.total) as SumForFieldTotal, ;
>>	SUM( Table1.quant) as SumForFieldQuant, ;
>>	Field3 ;
>>FROM Table1 ;
>>JOIN table3  ;
>>ON Table1.cod = table3.code ;
>>where table3.field4 = 1  ;
>>GROUP BY Field3, CodeField ;
>>UNION ALL select  ;
>>	table2.cod as CodeField, ;
>>	sum( table2.total) as SumForFieldTotal, ;
>>	sum( table2.quant) as SumForFieldQuant,  ;
>>	Field3  ;
>>	FROM table2 ;
>>	JOIN table3  ;
>>	ON table2.cod = table3.code  ;
>>	WHERE table3.field4 = 1 ;	
>>	GROUP BY Field3, CodeField ;
>>ORDER BY CodeField
>>

>>
>>
>>>>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.
>>>
>>>Can you post your current code so we would know the problem?