>Hi Hilmar,
>
>mmm, i think is more complicate, (sorry for not explain me better in last question)
>
>My SELECT is this one, and the values are in the inner join table,

It doesn't matter if the values are in another table of the SELECT; you can still use expressions of the type sum(expression) as FieldName to get a total, and group by to indicate which records should be combined.

>

>lcCmd = "SELECT * FROM    tbl_gc_DocumentosCabTer  a"  + ;
>            " inner join      tbl_gc_DocumentosLinTer b on a.c_Cod_Arm +
>           a.c_Cod_Doc+a.c_num_doc=b.c_Arm_Cab + b.c_Cod_Doc+b.c_num_doc" + ;
>           " left outer join tbl_gc_clientes c" + ;
>           " on a.c_cod_ter=c_codigo where a.c_Cod_Arm +
>           a.c_Cod_Doc+a.c_num_doc= '" + tcID + "' "
>
>

>
>>What does the field "Tax" contain; a code for the tax type?
>No, there is the real Value for TAX, in this ex: i show only 1,2,3 for test propouse.
>
>João Batista