>Hi Jim,
>
>Your query produces better results BUT.... two rows for each T1 record and you cannot distinguish the amounts as to source (T2 OR T3). So if I am trying to construct a view containing Invoice total charges and Invoice total payments as separate fields I am SOL it appears. Looks like it has to be done programatically or thru a series of queries, to build a cursor that can support a grid.
>
>Ken

Ken,

This should work for you;

SELECT T1.Id, "T2" AS SourceTable , SUM(T2.Amount) ;
  FROM T1 INNER JOIN T2 ON T1.ID = T2.Fid ;
 UNION ALL ;
 SELECT T1.ID, "T3" AS SourceTable, SUM(T3.Amount) ;
   FROM T1 INNER JOIN T3 ON T1.ID = T3.Fid ...