>But the query requires that I group by all the fields in the SELECT portion
>
>

If you need SUM of the fields, you only need to group by ID and add SUM for other fields, e.g.

SELECT	t.iTrading_Partner_ID,
>>>		SUM(tp.sTP_Name1) as sTP_Name1,
>>>		SUM(tar.AR) as AR,
>>>		SUM(tdp.Depo) as Depo,
etc.

>>You can group only by iTrading_Partner_ID and add SUM for all other column.
>>

UPDATE. I see that Eric beat me by few minutes while I was working on my own SQL script.