select A.Field1, B.Field2, C.Field3, D.Field4, ; (select SUM(E.Field5)from EFile E where E.kEKey = B.kBKey) as aTotal ; from AFile A ; join BFile B on B.kBKey1 = A.kAKey ; left join CFile C on B.kBkey2 = C.kCkey ; left join DFile D on B.kBKey3 = D.kDKey ; where A.AKey = ?gkKey ; order by C.Field3, D.Field4All the tables above are quite large, except “EFile”, which is found only in the sub-select. As I develop the system, the EFile table is only a handful of records long right now, although it will be growing in the future. All of the Key fields above are indexed. Typical resulting cursor is about 2 to 8 rows. The real code is more complex, but conceptually the same.